DS0-001 · Question #110
Which of the following statements best classifies a rollback in a database?
The correct answer is D. TCL. ROLLBACK belongs to Transaction Control Language (TCL) - the subset of SQL commands that manage transactions, including COMMIT, SAVEPOINT, and ROLLBACK. These commands control whether changes made during a transaction are permanently saved or undone. A (DDL) is wrong - Data…
Question
Which of the following statements best classifies a rollback in a database?
Options
- ADDL
- BDCL
- CDML
- DTCL
How the community answered
(69 responses)- A4% (3)
- B6% (4)
- C1% (1)
- D88% (61)
Explanation
ROLLBACK belongs to Transaction Control Language (TCL) - the subset of SQL commands that manage transactions, including COMMIT, SAVEPOINT, and ROLLBACK. These commands control whether changes made during a transaction are permanently saved or undone.
- A (DDL) is wrong - Data Definition Language defines database structure (
CREATE,ALTER,DROP); it doesn't manage transaction state. - B (DCL) is wrong - Data Control Language handles permissions (
GRANT,REVOKE); it has nothing to do with undoing changes. - C (DML) is wrong - Data Manipulation Language operates on data (
SELECT,INSERT,UPDATE,DELETE); it produces the changes that TCL then commits or rolls back.
Memory tip: Think of TCL as the "undo/save" layer sitting above DML. DML makes the edits; TCL decides whether they stick. If you remember "Transactions need Control," you'll always place ROLLBACK and COMMIT in TCL.
Topics
Community Discussion
No community discussion yet for this question.