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

Q. ‘character_set_database’ represents the character set used by the default database.

View solution

Q. The permitted value type for the variable ‘character_set_client’ is _____________

View solution

Q. Which system variable when set to 1, makes all temporary tables to get stored on disk rather than in memory?

View solution