Q. What is the command to disable autocommit and launch a transaction?

  • (A) INITIATE TRANSACTION
  • (B) *
  • (C) DISABLE AUTOCOMMIT
  • (D) TRANSACTION
💬 Discuss
✅ Correct Answer: (B) *
Explanation: This question is about starting a transaction in MySQL. Transactions are a way to group multiple SQL statements together so they are treated as one unit. If all the statements in a transaction are successful, the changes are committed to the database. But if any statement fails, all the changes are rolled back.

Published by Ranjeet ⭐ 34.60K Points at 22-Mar-2025 12:43 pm in MySQL

Explanation by: Ranjeet
This question is about starting a transaction in MySQL. Transactions are a way to group multiple SQL statements together so they are treated as one unit. If all the statements in a transaction are successful, the changes are committed to the database. But if any statement fails, all the changes are rolled back.

💬 Discussion

📊 Question Analytics

👁️
141
Total Visits
📽️
2 y ago
Published
🎖️
Ranjeet
Publisher
📈
83%
Success Rate