The effect of which of the following commands can never be reversed by the ROLLBACK command?
A) CREATE TABLE
B) ALTER TABLE
C) COMMIT
D) all of the above

Question

The effect of which of the following commands can never be reversed by the ROLLBACK command?​
A) ​CREATE TABLE
B) ​ALTER TABLE
C) ​COMMIT
D) ​all of the above

Quizplus · Accepted Answer

The ROLLBACK command is used to undo transactions that have not yet been saved to the database. However, the effects of the commands CREATE TABLE, ALTER TABLE, and COMMIT cannot be reversed by a ROLLBACK. CREATE TABLE and ALTER TABLE are DDL (Data Definition Language) commands, and their effects are auto-committed, meaning they cannot be undone. The COMMIT command is used to save all the transactions to the database permanently, so its effect also cannot be reversed by a ROLLBACK.

The Effect of Which of the Following Commands Can Never