V

Vishal Gupta • 7.73K Points
Tutor III 

Q. What is TRUE about SAVEPOINT?

  • (A) Following the completion of a transaction, it must be executed to save all the operations performed in the transaction.
  • (B) A transaction can be rolled back to its last saved state.
  • (C) A specific part of a transaction can be given a name
  • (D) None of the above

Correct answer: Option(C)

MySQL Share
Explanation by: Vishal Gupta 
In the case of the SAVEPOINT command, a specific part of a transaction can be given a name.

You must be Logged in to update hint/solution

Discusssion

Login to discuss.

Related MCQs on MySQL

Q. What is data in a MySQL database organized into?

Q. The mode used to turn on strict mode and all of the additional restrictions is . . . . . . . .

Q. What does the DESCRIBE Statement do?

Q. Select the correct statement

Q. On failure, 'mysql_query()' returns . . . . . . . .

Q. Which command is used to make a script file 'run_me.sh' executable?

Q. How many of the following does not return a value? mysql_close(), mysql_init, mysql_real_connect

Q. The place where the server stores its databases and status files are called the data directory.

Q. Any client in the client/server architecture of MySQL can change how the server behaves in relation to itself without impact on other clients.

Q. A view can be deleted using the command __________

Learn All MySQL MCQs