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

Q. The line that is written at the top of the script to write a Perl script using CGI.pm is ___________

View solution

Q. What does CGI stand for?

View solution

Q. Which module links DBI to the web?

View solution

Q. Which string function returns the index of the first occurrence of substring?

View solution