T

Tina Singh • 10.85K Points
Tutor II 

Q. What does the ROLLBACK Statement do?

  • (A) Changes made in the SQL database transaction are permanently saved using this SQL statement.
  • (B) Specify the columns of the table in this SQL statement to return distinct values.
  • (C) By running this SQL statement, the transaction will be undone and the operations not yet saved to the SQL database will be undone.
  • (D) An index is created in a SQL database table with this SQL statement.
  • Correct Answer - Option(C)
  • Views: 107
  • Filed under category MySQL
Explanation by: Tina Singh 
By running ROLLBACK SQL statement, the transaction will be undone and the operations not yet saved to the SQL database will be undone.

You must be Logged in to update hint/solution

Discusssion

Login to discuss.

Related MCQs on MySQL

Q. The option that supplies the pathname to root directory of MySQL installation is

Q. The maximum number of indexes on MyISAM table is . . . . . . . .

Q. In the following SQL command "*" stands for? SELECT * FROM person;

Q. PL/SQL programs are written as lines of text using a specific set of characters.

Q. A BIT value in a result set is displayed as a binary string.

Q. Which program is used as a utility for MyISAM table maintenance?

Q. Which variable is used as a handle to an open file?

Q. What is the maximum collations a character set can have?

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

Q. Which of the following is not MySQL String Data Type?

Learn All MySQL MCQs

Question analytics