Q. Which of these returns a string containing an error message?

View solution

Q. Which of the following returns a MySQL-specific numeric code?

View solution

Q. Which of the following returns an SQLSTATE code?

View solution

Q. The argument to the function mysql_error() is _______________

View solution

Q. What does mysql_real_connect() return if it fails?

View solution

Q. The function load_defaults() reads the option files.

View solution

Q. All API calls return a value.

View solution

Q. The general statement-issuing routine is _______________

View solution

Q. For failure, mysql_query() returns _______________

View solution

Q. How many of the following return rows?

SELECT, SHOW, DESCRIBE

View solution

Q. mysql_fetch_row() returns _______________

View solution

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

View solution

Q. mysql_store_result() does not return a result set.

View solution

Q. How many of the following is considered as a special character by ‘mysql_real_escape_string()’?

null byte, single quote, backslash

View solution

Q. What enables encrypted connections to be established?

View solution

Q. The exec_stmt_ssl is written in _______________

View solution

Q. On failure, ‘mysql_query()’ returns _______________

View solution

Q. Input handling cannot be customized with MySQL.

View solution

Q. By default, MySQL does not clip out of range numeric values to the nearest fit value.

View solution

Q. Which table in the ‘INFORMATION_SCHEMA’ stores information about storage engines and server plugins?

View solution