Which keyword inserted in the SHOW STATUS statement shows the values for the current connection?(a) GLOBAL(b) SESSION(c) LOCAL(d) DEFAULTI got this question by my school principal while I was bunking the class.This intriguing question originated from Status Variables in section System, Status and User Variables of MySQL

Which keyword inserted in the SHOW STATUS statement shows the values f

1.	Which keyword inserted in the SHOW STATUS statement shows the values for the current connection?(a) GLOBAL(b) SESSION(c) LOCAL(d) DEFAULTI got this question by my school principal while I was bunking the class.This intriguing question originated from Status Variables in section System, Status and User Variables of MySQL
Answer» The CORRECT option is (b) SESSION Explanation: The OPTIONAL ‘GLOBAL’ keyword in the statement SHOW [GLOBAL \| SESSION] STATUS statement aggregates the values over all connections and ‘SESSION’ SHOWS the values for the current connection.

Discussion

No Comment Found

Related InterviewSolutions

What does mysql_query() return on failure?(a) 0(b) 1(c) -1(d) a non-zeroI got this question in an internship interview.This key question is from User-Defined Variables in division System, Status and User Variables of MySQL
The option that enables multiple-statement execution is ____________(a) CLIENT_MULTI_STATEMENTS(b) CLIENT_STATEMENTS_MULTI(c) MULTI_STATEMENTS_CLIENT(d) MULTI_CLIENTS_STATEMENTSThe question was posed to me in a national level competition.I want to ask this question from User-Defined Variables in division System, Status and User Variables of MySQL
Multiple statement execution is disabled by default.(a) True(b) FalseI got this question during an internship interview.My question is taken from User-Defined Variables topic in chapter System, Status and User Variables of MySQL
What is the type of Audit_log_events system variable?(a) string(b) integer(c) float(d) doubleThe question was asked during an online interview.Question is taken from User-Defined Variables topic in chapter System, Status and User Variables of MySQL
Hexadecimal values assigned to user variables are treated as _____________(a) strings(b) non binary strings(c) binary strings(d) integersThis question was posed to me in class test.I would like to ask this question from User-Defined Variables topic in section System, Status and User Variables of MySQL
User defined variables are session specific.(a) True(b) FalseI got this question during a job interview.Question is from User-Defined Variables in portion System, Status and User Variables of MySQL
The columns containing a binary value that include null bytes will print properly using the %s printf() format specifier.(a) True(b) FalseI have been asked this question during an interview.My question is taken from Status Variables topic in section System, Status and User Variables of MySQL
What does mysql_fetch_row() return?(a) integer(b) float(c) structure(d) pointerThe question was posed to me during an interview for a job.The doubt is from Status Variables topic in division System, Status and User Variables of MySQL
The option that executes all SQL statements in a SQL script irrespective of the number of errors is ____________(a) –ensure(b) –force(c) –violent(d) –runThis question was posed to me during an interview.My enquiry is from Status Variables topic in section System, Status and User Variables of MySQL
mysql_next_result() does not return a status.(a) True(b) FalseThe question was asked in an online interview.I want to ask this question from Status Variables in chapter System, Status and User Variables of MySQL

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment