Explore topic-wise InterviewSolutions in .

The CORRECT answer is (a) RENAME

The explanation: To CHANGE the NAME of a table, the keyword ‘RENAME’ can be used. It can be used with the ‘ALTER TABLE’ CLAUSE. It can also be used as a statement in itself like ‘RENAME TABLE old_tbl new_tbl’.

The correct choice is (a) DROP INDEX

Best explanation: MySQL provides statements to change the structure of TABLES. To add or REMOVE the indexes on the existing database tables, the ‘CREATE INDEX’ and ‘DROP INDEX’ tables are used.

Right option is (b) ALTER

Best explanation: The ‘ALTER TABLE’ STATEMENT is used to make changes to GLOBAL attributes of the database. This statement is followed by the name of the database, character SET and COLLATION.

The correct option is (a) USE

The BEST I can explain: MySQL has the facility to use various statements specifically at the DATABASE LEVEL. For selecting a default database, the keyword or clause used is the ‘USE’ STATEMENT.

Correct answer is (d) more than 1

The EXPLANATION is: The MySQL SERVER allows simultaneous use of MULTIPLE CHARACTER SETS. A given character set is allowed to have one or more collations. It can be chosen according to the need of the database.

Right answer is (a) True

For explanation: The binary protocol is more DIFFICULT to use because more setup is NECESSARY for transmitting and receiving data values. The binary protocol does not support all STATEMENTS LIKE ‘USE’.

The CORRECT OPTION is (a) True

The BEST I can explain: The binary protocol is more difficult to use because more setup is NECESSARY for transmitting and receiving data values. The binary protocol does not SUPPORT all statements, for example, ‘USE’.

Correct OPTION is (B) SELECT * FROM `sampledb`.`member`

For explanation: When quotes is being used to refer to a qualified name, the individual IDENTIFIERS are quoted WITHIN the name SEPARATELY. So, the database name `sampledb` and table name `tbl` are quoted separately.

The correct option is (b) –force

To ELABORATE: 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.

The CORRECT choice is (a) CLIENT_MULTI_STATEMENTS

Explanation: 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.

Correct OPTION is (B) False

The EXPLANATION is: 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.

Correct answer is (a) sql_mode

Easiest explanation: The system variable ‘sql_mode’ is USED by the MYSQL server to configure the SQL mode. It has an impact on various aspects of the SQL statement EXECUTIONS. The other variables do not exist in the server.

Right OPTION is (a) .my.cnf

The BEST explanation: In Unix an option file is SET up by creating a file named ‘~/.my.cnf’ in the HOME directory. ‘C:\my.ini’ is the option file that is setup in WINDOWS. An option file stores the connection parameters.

Right ANSWER is (d) Ctrl-A

For EXPLANATION I would say: Control-A moves the CURSOR to the beginning of the LINE. Ctrl-E moves the cursor to the end of the line. Control-D deletes the character under the cursor whereas Esc-a is not valid.

Correct option is (a) NULL

For explanation I WOULD SAY: In MySQL, NULL is not comparable to other KNOWN values. It will result in a NULL when COMPARED to any value. The following statement would result in four NULLs: ‘SELECT NULL = 0, NULL < 0, NULL <> 0, NULL > 0′.

Right choice is (d) LIKE

Easiest EXPLANATION: The ‘LIKE’ clause filters INFORMATION that match a given PATTERN. ‘WHERE’ clause SELECTS information that is specified by a condition. ‘IS’ is used to match the EXACT condition specified.

Right answer is (a) True

To ELABORATE: Writing an application that uses the embedded server is different from writing one that OPERATES in a client/server context. A program that is WRITTEN as a client/server application can easily be converted to USE the embedded server.

Correct CHOICE is (B) False

For explanation: In MySQL, an EMBEDDED APPLICATION INCLUDES both a client side and a server side, in order that it can process one group of options for the client and another group for the server.

Correct ANSWER is (a) –with-embedded-server

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.

Right CHOICE is (a) ENGINES, PLUGINS

Best explanation: The ‘INFORMATION_SCHEMA’ is very useful in MySQL. It has many tables each SERVING its individual purpose. The storage ENGINE INFORMATION is stored in ENGINES and PLUGIN information in PLUGINS.

Right choice is (a) SHOW TABLE STATUS

The BEST I can explain: MySQL provides a METHOD to determine the storage engine for each table with the ‘SHOW TABLE STATUS’ statement. The OUTPUT of this statement is the name of the storage engine indicator.

The correct answer is (d) ALLOW_INVALID_DATES

To elaborate: In MySQL, it is also possible to selectively weaken the STRICT MODE in some places. If the ALLOW_INVALID_DATES SQL mode is ENABLED, MySQL doesn’t PERFORM full checking of the date parts.

Correct answer is (b) False

For explanation: For the numeric or TIME columns, the values that are OUTSIDE the legal range are CLIPPED to the nearest ENDPOINT of the range. The resulting value is stored. This is the method to HANDLE defaults for numerics.

The correct answer is (b) False

The explanation: With MYSQL, raw SQL STATEMENTS can be entered. With MySQL PROGRAMS input methods can be provided for the user that are more intuitive and easier to be USED. So input handling is CUSTOMIZED.

The correct option is (a) exec_stmt_ssl

Easiest explanation: For the ‘exec_stmt_ssl’ to WORK PROPERLY, MySQL must have been BUILT with SSL support, and the server must be started with the PROPER options that identify its certificate and key FILES.

Correct choice is (B) False

For explanation I would say: The FUNCTIONS ‘mysql_store_result()’ and ‘mysql_use_result()’ are SIMILAR because both of them TAKE a connection handler argument and then return a RESULT set after carrying out processes.

Right choice is (a) True

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.

Right choice is (d) a non-zero

The best I can EXPLAIN: 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 answer is (a) mysql_real_query()

Best explanation: The general STATEMENT-issuing routine is mysql_real_query(). The statement is provided as a counted STRING (a string plus a length). The length of the statement string must be KEPT track of.

The CORRECT answer is (B) False

To EXPLAIN: In MySQL, not all the API calls return a VALUE. The client routine NAMED ‘mysql_close()’ is one that does not. The API calls that return a value are ‘mysql_sqlstate()’, ‘mysql_error()’ etc.

The correct CHOICE is (c) all

For explanation I WOULD SAY: The connection protocol used by the option ‘–protocol = TCP’ indicates TCP/IP connection to the local or the remote server. Each –protocol value has the set of the PERMISSIBLE OS.

The correct answer is (a) True

The best explanation: The function named ‘load_defaults()’ READS the OPTION files. It takes four arguments. It does not PICK up values from the environment SETTINGS. All connection parameters can be BROUGHT to the argument vector.

The correct ANSWER is (d) NULL

The EXPLANATION is: The function ‘mysql_real_connect()’ must COMPLETE SUCCESSFULLY before any other API functions that require a valid MYSQL CONNECTION handler structure can be executed. It returns NULL on failure.

Right choice is (C) mysql_sqlstate()

BEST explanation: The MySQL API call named ‘mysql_sqlstate()’ returns an SQLSTATE code. This SQLSTATE VALUE is more ‘vendor NEUTRAL’ because it is based on the ‘ANSI SQL’ and ‘ODBC’ standards.

The CORRECT option is (b) mysql_errno()

The explanation is: The API CALL NAMED ‘mysql_errorno()’ returns a MySQL-specific numeric error CODE. ‘mysql_error()’ returns a string containing an error message. ‘mysql_close()’ does not return any value at all.

The correct ANSWER is (a) mysql_error()

To elaborate: 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.

Correct ANSWER is (B) unix only

Explanation: The connection protocol used by the option ‘–protocol = SOCKET’ indicates the unix socket FILE connection to the LOCAL server. Each –protocol VALUE has the set of permissible OS.

The correct OPTION is (a) all

The best EXPLANATION: The connection protocol used by the option ‘–protocol = TCP’ indicates TCP/IP connection to the local or the remote SERVER. Each –protocol value has the set of permissible OS.