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

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

null byte, single quote, backslash

View solution

Q. The embedded server library containing the MySQL server linkable into applications is _______________

View solution

Q. When building from source, the embedded server library is enabled by _______________

View solution

Q. An embedded application includes the server side only.

View solution

Q. Converting a client/server application to embedded server is simpler.

View solution

Q. Which clause is used to display information that matches a given pattern?

View solution

Q. Comparing a known value with NULL results into _______________

View solution

Q. Which is the command to move the cursor to the beginning of line in mysql input editor?

View solution

Q. The name of the option file in Unix is __________

View solution