Examveda

Which keyword inserted in the SHOW STATUS statement shows the values for the current connection?

A. GLOBAL

B. SESSION

C. LOCAL

D. DEFAULT

Answer: Option B

Solution (By Examveda Team)

This question is asking about a special word you can use in MySQL to see information about the current connection you are using. This information might include things like what database you are connected to, what your user permissions are, and how long you've been connected.
The keyword you need to use is SESSION.
Let's break down why the other options aren't correct:
GLOBAL - This keyword shows information about the entire MySQL server, not just your current connection.
LOCAL - This keyword is not used with the SHOW STATUS statement.
DEFAULT - This keyword isn't related to the SHOW STATUS statement.
So the answer is Option B: SESSION.

This Question Belongs to MySQL >> MySQL Miscellaneous

Join The Discussion

Related Questions on MySQL Miscellaneous