Oracle Database 11g: SQL Fundamentals I — Question 3

Which statement is true regarding transactions? (Choose all that apply.)

Answer options

• A. A transaction can consist only of a set of DML and DDL statements.
• B. A part or an entire transaction can be undone by using ROLLBACK command.
• C. A transaction consists of a set of DML or DCL statements.
• D. A part or an entire transaction can be made permanent with a COMMIT.
• E. A transaction can consist of only a set of queries or DML or DDL statements.

Correct answer: B, C

Explanation

Option B is correct because the ROLLBACK command allows undoing parts or the entirety of a transaction. Option C is also correct as transactions can consist of DML or DCL statements. The other options are incorrect because they misrepresent the composition and functions of transactions in database management.