Multiple statement execution is not enabled by default.
A. True
B. False
Answer: Option A
Solution (By Examveda Team)
This question is about how MySQL handles multiple commands you write in a single query.Imagine you want to do several things at once, like:
1. Create a new table
2. Add some data to it
3. Update some of the data
You might try writing all three commands in one go, like this:
CREATE TABLE my_table (name VARCHAR(255));
INSERT INTO my_table (name) VALUES ('Alice'), ('Bob');
UPDATE my_table SET name = 'Charlie' WHERE name = 'Bob';
But by default, MySQL doesn't let you run all these commands at once. It expects each command to be separate.
So the answer is Option A: True.
You can enable multiple statement execution if you need it, but it's not the standard behaviour.
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