Which TCL command undo all the updates performed by the SQL in the transaction?

Related MCQs

• Which of the following command makes the updates performed by the transaction permanent in the database?
• If                        are not obtained in undo operation it will cause problem in undo- phase.
• If several concurrent transactions are executed over the same data set and the second transaction updates the database before the first transaction is finished, the ____ property is violated and the database is no longer consistent.
• Which of the following are TCL commands?
• In SQL, which command is used to issue multiple CREATE TABLE, CREATE VIEW and GRANT statements in a single transaction?
• In order to undo the work of transaction after last commit which one should be used?
•                        refers to the ability of the system to recover committed transaction updates if either the system or the storage media fails.
• If an transaction is performed in a database and committed, the changes are taken to the previous state of transaction by
• The command                                  such tables are available only within the transaction executing the query and are dropped when the transaction finishes.
•                  dump, writes out SQL DDL statements and SQL insert statements to a file, which can then be reexecuted to re- create the database.