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

View solution

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

View solution

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

View solution

Q. Which module links DBI to the web?

View solution

Q. What does CGI stand for?

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 is the shebang line?

View solution

Q. Which of these is a read only variable?

View solution

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