What is the command to disable autocommit and launch a transaction?
A. INITIATE TRANSACTION
B. START TRANSACTION
C. DISABLE AUTOCOMMIT
D. TRANSACTION
Answer: Option B
Solution (By Examveda Team)
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.The command to disable autocommit and launch a transaction is START TRANSACTION.
Here's why the other options are incorrect:
INITIATE TRANSACTION is not a valid MySQL command.
DISABLE AUTOCOMMIT only disables autocommit, but it doesn't start a transaction.
TRANSACTION is not a command but a keyword used in other commands.
Therefore, the correct answer is Option B: START TRANSACTION
Related Questions on MySQL Miscellaneous
How is communication established with MySQL?
A. SQL
B. Network calls
C. A programming language like C++
D. APIs
Which type of database management system is MySQL?
A. Object-oriented
B. Hierarchical
C. Relational
D. Network
Join The Discussion