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: 113
  • 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.

Be the first to start discuss.

Related MCQs on MySQL

Q. To maintain performance of tables having variable length rows, which statement is used?

Q. Consider a database name "db_name" whose attributes are intern_id (primary key), subject, subject_value. Intern_id = {1, 2, 3, 4, 5, 6} Subject = {sql, oop, sql, oop, c, c++} Subject_value = {0, 0, 1, 1, 2, 2, 3, 3} If these are one to one relation then what will be the output of the following MySQL statement? SELECT intern_id FROM db_name WHERE subject IN (SELECT subject FROM db_name WHERE subject_value = 3);

Q. Are “Datetime” and “Timestamp” the same data type?

Q. mysql_init() returns a _____________.

Q. The slow query log is written as . . . . . . . .

Q. A collection method is a built-in function or procedure that operates on collections and is called using dot notation.

Q. If emp_id contain the following set {-1, -2, 2, 3, -3, 1}, what will be the output on execution of the following MySQL statement? SELECT emp_id FROM person ORDER BY emp_id;

Q. The log enabled by -relay-log-index is . . . . . . . .

Q. MySQL does provides a date type that has an optional time part.

Q. In which language MYSQL is written?

Learn All MySQL MCQs

Question analytics