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

View solution

Q. The synonym for last_insert_id session variable is _____________

View solution

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

View solution

Q. What returns a string containing an error message?

View solution

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

View solution

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

View solution

Q. What is the synonym for last_insert_id session variable?

View solution

Q. The Audit_log_events system variable is of type _____________

View solution

Q. mysql_next_result() does not return a status.

View solution

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

View solution

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

SELECT, SHOW, DESCRIBE

View solution

Q. What does mysql_fetch_row() return?

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. User defined variables are session specific.

View solution

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

View solution

Q. What is the type of Audit_log_events system variable?

View solution

Q. Multiple statement execution is disabled by default.

View solution

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

View solution

Q. What does mysql_query() return on failure?

View solution