Bird
0
0

Which of the following is the correct SQL command to start a transaction?

easy📝 Syntax Q3 of 15
SQL - Transactions and Data Integrity
Which of the following is the correct SQL command to start a transaction?
ASTART TRANSACTION;
BBEGIN TRANSACTION;
COPEN TRANSACTION;
DINITIATE TRANSACTION;
Step-by-Step Solution
Solution:

  1. Step 1: Recall SQL syntax for starting transactions

    Standard SQL uses START TRANSACTION to begin a transaction block.

  2. Step 2: Check other options

    BEGIN TRANSACTION is used in some systems but not standard; OPEN and INITIATE are invalid commands.

  3. Final Answer:

    START TRANSACTION; -> Option A

  4. Quick Check:

    Start transaction command = B [OK]
Quick Trick: Use START TRANSACTION to begin a transaction [OK]
Common Mistakes:
  • Using BEGIN TRANSACTION in non-supporting systems
  • Using invalid commands like OPEN TRANSACTION

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