Examveda

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.

This Question Belongs to MySQL >> MySQL Miscellaneous

Join The Discussion

Related Questions on MySQL Miscellaneous