Bird
0
0

Which SQL command is used to initiate a transaction block?

easy📝 Syntax Q3 of 15
SQL - Transactions and Data Integrity
Which SQL command is used to initiate a transaction block?
ABEGIN QUERY;
BOPEN TRANSACTION;
CSTART TRANSACTION;
DINIT TRANSACTION;
Step-by-Step Solution
Solution:
  1. Step 1: Recall transaction syntax

    SQL uses specific commands to start transactions.
  2. Step 2: Identify correct command

    "START TRANSACTION;" is the standard command to begin a transaction block.
  3. Final Answer:

    START TRANSACTION; -> Option C
  4. Quick Check:

    START TRANSACTION begins a transaction [OK]
Quick Trick: Use START TRANSACTION to begin a transaction block [OK]
Common Mistakes:
  • Using non-existent commands like OPEN TRANSACTION
  • Confusing transaction start with query commands
  • Assuming BEGIN QUERY starts a transaction

Want More Practice?

15+ quiz questions · All difficulty levels · Free

Free Signup - Practice All Questions
More SQL Quizzes