Oracle Database 12c: SQL Fundamentals — Question 30

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

Statement B is correct because the ROLLBACK command allows reverting changes made in a transaction. Statement C is also correct as it identifies that a transaction can consist of DML or DCL statements, but the other options contain inaccuracies regarding the nature of transactions or their components.