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

Q. The binary protocol is more difficult to use.

View solution

Q. The maximum collations a character set can have is ______________

View solution

Q. A synonym for CHARACTER SET is ______________

View solution

Q. The statement used to select a default database is ______________

View solution

Q. The statement that makes changes to the global attributes of the database is ______________

View solution

Q. The statement used to remove indexes on tables is ______________

View solution

Q. The statement used to change the table name is __________

View solution

Q. What is the general term for information about databases and the objects in MySQL?

View solution

Q. Perl scripts are text files.

View solution

Q. The shebang line is ______________

View solution