Bird
0
0

Which of the following SQL transaction commands is used to make all changes permanent, supporting the Durability property?

easy📝 Syntax Q12 of 15
SQL - Transactions and Data Integrity
Which of the following SQL transaction commands is used to make all changes permanent, supporting the Durability property?
AROLLBACK
BCOMMIT
CSAVEPOINT
DBEGIN TRANSACTION
Step-by-Step Solution
Solution:

  1. Step 1: Identify command for saving changes

    COMMIT saves all changes permanently, ensuring Durability.

  2. Step 2: Understand other commands

    ROLLBACK undoes changes, SAVEPOINT marks a point to rollback to, BEGIN TRANSACTION starts a transaction.

  3. Final Answer:

    COMMIT -> Option B

  4. Quick Check:

    Permanent save = COMMIT [OK]
Quick Trick: COMMIT makes changes permanent [OK]
Common Mistakes:
  • Choosing ROLLBACK to save changes
  • Confusing SAVEPOINT with COMMIT
  • Thinking BEGIN TRANSACTION saves data

Want More Practice?

15+ quiz questions · All difficulty levels · Free

Free Signup - Practice All Questions
More SQL Quizzes
Advanced Query Patterns - Conditional aggregation pattern - Quiz 6medium Common Table Expressions (CTEs) - CTE as readable subquery replacement - Quiz 2easy Common Table Expressions (CTEs) - Multiple CTEs in one query - Quiz 3easy Indexes and Query Performance - When indexes help and when they hurt - Quiz 1easy Indexes and Query Performance - Composite index and column order - Quiz 13medium Indexes and Query Performance - CREATE INDEX syntax - Quiz 1easy Triggers - UPDATE trigger with OLD and NEW - Quiz 11easy Window Functions Fundamentals - NTILE for distribution - Quiz 13medium Window Functions Fundamentals - RANK and DENSE_RANK difference - Quiz 1easy Window Functions Fundamentals - ROW_NUMBER function - Quiz 10hard