The option that enables multiple-statement execution is . . . . . . . .
A. CLIENT_MULTI_STATEMENTS
B. CLIENT_STATEMENTS_MULTI
C. MULTI_STATEMENTS_CLIENT
D. MULTI_CLIENTS_STATEMENTS
Answer: Option A
Solution (By Examveda Team)
This question is asking about a MySQL option that lets you run multiple SQL commands in one go.Imagine you want to do two things: create a new table and then insert some data into it. Instead of running separate commands, you can use this option to run them together.
Out of the given options, only CLIENT_MULTI_STATEMENTS is the correct answer.
The other options are not valid MySQL options.
So, if you want to run multiple SQL statements in one go, use the CLIENT_MULTI_STATEMENTS option.
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