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

Q. System variable in MySQL server that enables to configure the SQL mode is __________

View solution

Q. Multiple statement execution is enabled by default.

View solution

Q. Which option enables multiple-statement execution?

View solution

Q. mysql_next_result() returns a status.

View solution

Q. To see the table structure which command is issued?

View solution

Q. Which character is illegal in naming an unquoted identifier in SQL?

View solution

Q. Which statement is valid if ‘`sampledb`’ is a database and ‘`tbl`’ is a table in it?

View solution

Q. The default case sensitivity of the database and table names depends on ___________

View solution

Q. To how many of the following does the prepared-statement API apply to?

CREATE TABLE, DELETE, DO, INSERT

View solution

Q. The binary protocol does not support all statements.

View solution