The statement that views status variables by aggregating the values over all connections is _____________(a) SHOW SESSION STATUS(b) SHOW LOCAL STATUS(c) SHOW GLOBAL STATUS(d) SHOW STATUSI have been asked this question in class test.Query is from Status Variables in chapter System, Status and User Variables of MySQL

The statement that views status variables by aggregating the values ov

1.	The statement that views status variables by aggregating the values over all connections is _____________(a) SHOW SESSION STATUS(b) SHOW LOCAL STATUS(c) SHOW GLOBAL STATUS(d) SHOW STATUSI have been asked this question in class test.Query is from Status Variables in chapter System, Status and User Variables of MySQL
Answer» The correct CHOICE is (c) SHOW GLOBAL STATUS For explanation: The MYSQL server MAINTAINS various status variables that provide INFORMATION about its operations. These variables and their values can be viewed by using the SHOW [GLOBAL \| SESSION] STATUS statement.

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