DS0-001 · Question #110
DS0-001 Question #110: Real Exam Question with Answer & Explanation
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 Defin
Question
Which of the following statements best classifies a rollback in a database?
Options
- ADDL
- BDCL
- CDML
- DTCL
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.
Community Discussion
No community discussion yet for this question.