Q. The option that enables multiple-statement execution is ____________

View solution

Q. Multiple statement execution is disabled by default.

View solution

Q. What is the type of Audit_log_events system variable?

View solution

Q. Hexadecimal values assigned to user variables are treated as _____________

View solution

Q. User defined variables are session specific.

View solution

Q. The columns containing a binary value that include null bytes will print properly using the %s printf() format specifier.

View solution

Q. What does mysql_fetch_row() return?

View solution

Q. How many of the following do not return rows?

SELECT, SHOW, DESCRIBE

View solution

Q. The option that executes all SQL statements in a SQL script irrespective of the number of errors is ____________

View solution

Q. mysql_next_result() does not return a status.

View solution

Q. The Audit_log_events system variable is of type _____________

View solution

Q. What is the synonym for last_insert_id session variable?

View solution

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

View solution

Q. The statement that views status variables by aggregating the values over all connections is _____________

View solution

Q. What returns a string containing an error message?

View solution

Q. When building from source, the embedded server library is enabled by what?

View solution

Q. The synonym for last_insert_id session variable is _____________

View solution

Q. Which variable when set to 1 would enable foreign key checking for InnoDB tables?

View solution

Q. Which of these is a read only variable?

View solution

Q. What is the shebang line?

View solution