Q. Which of the following can be used interchangeably with MYSQL_VERSION_ID?

View solution

Q. Which option is supplied to ensure TCP/IP connection to local server?

View solution

Q. Connections to remote servers always use TCP/IP.

View solution

Q. The –protocol value ‘TCP’ runs on which operating systems?

View solution

Q. The ‘SOCKET’ protocol is permitted on which operating systems?

View solution

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