SQL - Transactions and Data Integrity
Which of the following is the correct way to start a transaction in SQL?
Which of the following is the correct way to start a transaction in SQL?
easy📝 Syntax Q12 of 15
Step-by-Step Solution
Solution:
Step 1: Recall SQL syntax for transactions
The standard way to start a transaction is usingSTART TRANSACTION;orBEGIN TRANSACTION;.Step 2: Check each option
START TRANSACTION; is the most widely supported and standard syntax. CREATE TRANSACTION and OPEN TRANSACTION are invalid. BEGIN TRANSACTION is valid in some systems but START TRANSACTION is more standard.Final Answer:
START TRANSACTION; -> Option CQuick Check:
Start transaction command = START TRANSACTION [OK]
Quick Trick: Use START TRANSACTION to start safely [OK]
Common Mistakes:
- Using CREATE TRANSACTION which is invalid
- Confusing START TRANSACTION with BEGIN TRANSACTION
- Trying OPEN TRANSACTION which doesn't exist
Master "Transactions and Data Integrity" in SQL
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore SQL Quizzes