Oracle Database SQL — Question 208

Which two are true about rollbacks? (Choose two.)

Answer options

• A. The ROLLBACK statement does not release locks resulting from table updates.
• B. Data consistency is not guaranteed after a rollback.
• C. A transaction interrupted by a system failure is automatically rolled back.
• D. If the ROLLBACK statement is used without TO SAVEPOINT, then all savepoints in the transaction are deleted.
• E. Data Control Language (DCL) statements, such as GRANT and REVOKE, can be rolled back.

Correct answer: C, D

Explanation

Option C is correct because transactions interrupted by system failures are automatically reverted to maintain data integrity. Option D is also correct as using ROLLBACK without TO SAVEPOINT removes all savepoints. The other options are incorrect; A is wrong because the ROLLBACK statement does release locks, B is incorrect as data consistency is generally assured after a rollback, and E is false because DCL statements cannot be rolled back.