Explore topic-wise InterviewSolutions in .

Correct option is (d) a non-zero

To ELABORATE: Both of the functions named ‘mysql_query()’ and ‘mysql_real_query()’ return zero for statements that SUCCEED. They return non zero for failure. A STATEMENT is successfully executed if the SERVER accepts it.

The correct choice is (a) CLIENT_MULTI_STATEMENTS

For explanation I would say: There are two WAYS to enable the multiple-statement execution. The FIRST is to add the ‘CLIENT_MULTI_STATEMENTS’ OPTION in the FLAGS argument to ‘mysql_real_connect()’ at connect TIME.

The correct CHOICE is (a) True

Easy explanation: The ‘multiple-statement’ EXECUTION is not enabled by DEFAULT, so the server must be told that it is INTENDED to be used. There are two WAYS to tell the server to enable the execution.

Right choice is (a) True

For explanation I would say: The user defined variables are session specific. A user variable defined by ONE client cannot be seen or used by other CLIENTS. A user with access to the PERFORMANCE Schema user_variables_by_thread table can see all user variables for all SESSIONS is an exception.

Correct option is (b) False

For explanation: The columns containing binary value including null BYTES do not print properly using the %s printf() FORMAT SPECIFIER. printf() EXPECTS a null terminated string. It prints the column value only up to the first null byte.

The correct choice is (b) –force

Best explanation: If SQL queries in a file are run using mysql in batch mode, mysql either QUITS after the FIRST error. If the –force OPTION is specified all the queries are EXECUTED indiscriminately.

Right ANSWER is (b) False

Easiest EXPLANATION: The FUNCTION ‘mysql_next_result()’ returns a status and initiates retrieval of the next SET if more results are available. The status is zero if more results are available and -1 if not.

Right option is (B) integer

To elaborate: The system variable ‘Audit_log_events’ is of type integer. The variable SCOPE if GLOBAL, that is, it can be viewed by issuing the STATEMENT ‘SHOW GLOBAL STATUS’, INSTEAD of ‘SESSION’.

The CORRECT option is (b) identity

The explanation: The SESSION only system VARIABLE ‘identity’ is a synonym for the ‘last_insert_id’ session variable. Setting ‘last_insert_id’ specifies the VALUE to be returned by the function ‘LAST_INSERT_ID()’.

The CORRECT option is (b) SESSION

Explanation: The OPTIONAL ‘GLOBAL’ keyword in the statement SHOW [GLOBAL | SESSION] STATUS statement aggregates the values over all connections and ‘SESSION’ SHOWS the values for the current connection.

The correct CHOICE is (c) SHOW GLOBAL STATUS

For explanation: The MYSQL server MAINTAINS various status variables that provide INFORMATION about its operations. These variables and their values can be viewed by using the SHOW [GLOBAL | SESSION] STATUS statement.

Right choice is (a) mysql_error()

For explanation: The API call NAMED ‘mysql_error()’ RETURNS a string containing an error message. ‘mysql_close()’ does not RETURN any value at all. ‘mysql_errno()’ returns a MySQL-specific NUMERIC code.

Right ANSWER is (a) –with-embedded-SERVER

Easy explanation: While building from the source, the embedded server library is enabled by USING the option ‘–with-embedded-server’ while running ‘configure’. This applies equally to MySQL 5.0 and 5.1.

Correct CHOICE is (B) identity

To explain I would say: The session only system variable ‘identity’ is a synonym for the ‘last_insert_id’ session variable. Setting ‘last_insert_id’ specifies the VALUE to be returned by the FUNCTION ‘LAST_INSERT_ID()’.

The correct choice is (a) error_count

The EXPLANATION: The SESSION only system variable ‘error_count’ is a read only variable that indicates the number of errors generated by the last statement that can generate errors. The others are writable.

Correct CHOICE is (b) Common Gateway Interface

The explanation is: The ‘CGI.pm’ module is so called because it HELPS WRITE scripts that use the ‘Common Gateway Interface’ protocol which defines how a web server communicates with other PROGRAMS.

Right choice is (C) CGI.pm

Best explanation: The CGI.pm module is used to write SCRIPTS that use the ‘Common GATEWAY Interface’ protocol. It defines how a WEB server communicates with other programs. It provides an easy link.

Right choice is (b) INSTR()

The best I can explain: The string funtion ‘INSTR()’ is used to return the index of the FIRST occurrence of the substring. The FUNCTION ‘INSERT()’ is used to insert a substring at the SPECIFIED POSITION up to the specified number of characters.

The correct answer is (a) True

For explanation I would say: ‘character_set_database’ is the character SET used by the DEFAULT database. The server sets the VARIABLE WHENEVER the default database changes. If there is no default database the variable has the same value as ‘character_set_server’.

The correct option is (d) string

Best explanation: ‘character_set_client’ is the character SET for STATEMENTS that arrive from the client. The session value of this VARIABLE is set using the character set requested by the client when client CONNECTS to server.

Correct answer is (C) big_tables

Easy explanation: The variable ‘big_tables’ if SET to 1, all temporary tables are stored on disk rather than in memory. This is a little slower but the error ‘The table tbl_name is full’ does not occur for SELECT OPERATIONS that require a large temporary table.