Q1122
The option that enables multiple-statement execution is . . . . . . . .
A.
CLIENT_MULTI_STATEMENTS
AnswerB.
CLIENT_STATEMENTS_MULTI
C.
MULTI_STATEMENTS_CLIENT
D.
MULTI_CLIENTS_STATEMENTS
Answer: Option A
Solution
Answer: Option A
Solution:
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.