Explore topic-wise InterviewSolutions in .

Correct option is (c) subquerying

To EXPLAIN: The ‘subquerying’ support provided by MYSQL is a capability that allows writing one ‘SELECT’ statement within parentheses and NESTING within ANOTHER. This allows logically SELECTING content from tables.

Right OPTION is (d) RIGHT JOIN

For EXPLANATION I would say: In a ‘RIGHT JOIN’, the output is produced for EVERY row of the right table, even if it does not exist in the other table. This is the REASON why it is called a ‘RIGHT JOIN’. ‘RIGHT JOIN’ and ‘LEFT JOIN’ are a KIND of OUTER JOIN.

The correct CHOICE is (B) 1

To explain: The AUTO_INCREMENT COLUMN attribute provides unique numbers for column identification. AUTO_INCREMENT SEQUENCES normally begin at 1 and increase monotonically LIKE 1, 2, 3, and so on.

Correct option is (b) False

Explanation: ‘CGI.pm’ SUPPORTS an object ORIENTED style of use which allows to invoke its FUNCTIONS without IMPORTING the NAMES. To do this, a use statement is included and a CGI object is created.

Correct choice is (B) INSTR()

Explanation: The string function ‘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 OPTION is (c) SOUNDS LIKE

For explanation: The operator ‘SOUNDS LIKE’ is used to compare sound. The ‘RLIKE’ is a synonym for ‘REGEXP’, which is a PATTERN matching using REGULAR expressions. There are a lot of other operators for USE.

Right OPTION is (d) NULLIF()

The EXPLANATION: The ‘CASE’ is used for the case operator. The FUNCTION ‘IF()’ is used for the if/else construct. The function ‘IFNULL()’ is the NULL if/else construct. ‘NULLIF()’ RETURNS NULL if expr1 = expr2.

Correct answer is (b) –sql-mode=IGNORE_SPACE

For EXPLANATION I would SAY: The MYSQL server is told to accept spaces after FUNCTION names by starting it with the ‘–sql-mode=IGNORE_SPACE’ option. Individual client programs can request this behavior by USING the ‘CLIENT_IGNORE_SPACE’ option for ‘mysql_real_connect()’.

Correct choice is (a) 3.402823466E+38

The best I can EXPLAIN: In MySQL, each datatype has its own RANGE. DATA types give an idea of the kind of values and the ranges that a variable is allowed to store. The maximum non ZERO value for FLOAT is 3.402823466E+38.

The correct option is (B) column name

The best I can explain: The function ‘fetchrow_hashref()’ RETURNS a reference to the HASH of row VALUES, KEYED by the column name. The function ‘fetchrow_arrayref()’ returns a reference to an array of row values.

The CORRECT answer is (d) fetchrow_hashref()

Easiest EXPLANATION: The FUNCTION ‘fetchrow_hashref()’ returns REFERENCE to hash of row values. ‘fetchrow_arrayref()’ returns a reference to an array of row values. ‘fetch()’ is the same as fetchrow_arrayref().

Right choice is (a) fetchrow_array()

BEST explanation: The FUNCTION ‘fetchrow_array()’ RETURNS an array of row values. ‘fetchrow_arrayref()’ returns a REFERENCE to an array of row values. ‘FETCH()’ is the same as fetchrow_arrayref().

Correct ANSWER is (a) Rich Text Format

Best explanation: RTF (Rich Text Format) is a format developed by Microsoft that is understood by many WORD processors. MS-Word is ONE such PROGRAM. Many others such as ‘OpenOffice’ understand it too.

The correct answer is (c) SOUNDS LIKE

To explain: The operator ‘SOUNDS LIKE’ is USED to compare the SOUND. The ‘RLIKE’ is a synonym for ‘REGEXP’, which is a pattern matching using REGULAR expressions. There are a lot of other operators for use.

Right option is (d) $H

To explain I would say: The variable named ‘$fh’ is a handle to an open file. ‘$h’ is a GENERIC handle and the MEANING depends on context. ‘$dbh’ is a handle to a DATABASE object. ‘$STH’ is a handle to a query object.

The CORRECT OPTION is (b) False

To explain: MySQL automatically CONVERTS a date or time value into a number if the value is used in a numeric context and vice versa. A ‘ZERO’ value can also be represented in MySQL.

Right answer is (b) False

Explanation: The ‘SPATIAL’ INDEXES can be created on ‘NOT NULL’ spatial columns. Therefore, if it is planned to index the COLUMN, it WOULD NEED to be DECLARED as NOT NULL. This type can be used in many ways.

The correct ANSWER is (a) GEOMETRYCOLLECTION

Explanation: ‘GEOMETRYCOLLECTION’ can store a collection of objects of any TYPE. The other collection types LIKE ‘MULTIPOINT’, ‘MULTILINESTRING’, ‘MULTIPOLYGON’ and ‘GEOMETRYCOLLECTION’ restrict collection MEMBERS to those having a PARTICULAR geometry type.

The correct answer is (b) OpenGIS

To EXPLAIN I WOULD say: MySQL has spatial data types that correspond to OpenGIS CLASSES. Some of them that hold single GEOMETRY VALUES are ‘GEOMETRY’, ‘POINT’, ‘LINESTRING’ and ‘POLYGON’. Some can hold a collection of values.

The correct choice is (a) $dbh

For explanation I WOULD say: The VARIABLE named ‘$dbh’ is a handle to an open file. ‘$h’ is a generic handle and the MEANING DEPENDS on context. ‘$dbh’ is a handle to a database object. ‘$sth’ is a handle to a QUERY object.

The CORRECT answer is (c) $fh

For explanation I would SAY: The variable named ‘$fh’ is a HANDLE to an open file. ‘$h’ is a GENERIC handle and the meaning DEPENDS on context. ‘$dbh’ is a handle to a database object. ‘$sth’ is a handle to a query object.

Correct answer is (c) methods

Easiest EXPLANATION: In the DBI API, functions are called and pointers to structures are used. The functions are called ‘methods’, pointers are called ‘references’, POINTER VARIABLES are called ‘handles’.

The correct answer is (a) True

Easiest explanation: MySQL automatically converts a date or time VALUE into a number if the value is used in a numeric CONTEXT and vice versa. A ‘zero’ value can ALSO be REPRESENTED in MySQL.

Correct answer is (a) PAD_CHAR_TO_FULL_LENGTH

The explanation: When the CHAR values are stored, they are right-padded with spaces to the specified length. When CHAR values are RETRIEVED, trailing spaces are REMOVED UNLESS the SQL mode ‘PAD_CHAR_TO_FULL_LENGTH’ is ENABLED.

The CORRECT answer is (a) NO_ZERO_IN_DATE

Explanation: MySQL permits to store the DATES where the day or MONTH and day are zero in a DATE or DATETIME COLUMN. This is helpful for applications that need to store birthdates for which the exact date is unknown.

The correct answer is (a) my_global.h

Easy explanation: The file ‘my_global.h’ takes care of including several other header FILES that are likely to be generally useful, LIKE ‘stdio.h’. It also INCLUDES Windows COMPATIBILITY INFORMATION.

The correct answer is (B) my_sys.h

To ELABORATE: The ‘my_sys.h’ header file CONTAINS a variety of portability MACROS and definitions required for structures and functions. These structures and functions are used by the CLIENT library.

Correct option is (c) mysqlimport

Explanation: A way to create text DATA files ALONG with files containing ‘CREATE TABLE’ statements for the backed up tables is to USE ‘mysqldump’ with –tab. To RELOAD a delimited text data file ‘mysqlimport’ is used.

The correct answer is (b) –single-transaction

Explanation: For INNODB tables it is possible to perform an online BACKUP that takes no locks on tables USING the option ‘–single-transaction’ to ‘mysqldump’. The ‘mysqldump’ can make BACKUPS.

Right option is (b) -128

For EXPLANATION I would SAY: MySQL supports the SQL standard integer types INTEGER, or INT, and SMALLINT. As an extension to this standard, MySQL also supports the integer types TINYINT, MEDIUMINT and BIGINT.

Right choice is (a) PAD_CHAR_TO_FULL_LENGTH

For EXPLANATION: When the CHAR VALUES are stored, they are right-padded with spaces to the specified length. When CHAR values are retrieved, TRAILING spaces are removed unless the SQL mode ‘PAD_CHAR_TO_FULL_LENGTH’ is enabled.

Correct option is (c) 5

Easy explanation: ‘VARCHAR’ values are not padded when they are stored. The TRAILING spaces are RETAINED when values are stored and retrieved in CONFORMANCE with standard SQL. The given size is 5 BYTES.

The correct OPTION is (b) $a[0]

The best I can explain: If $a represents an ARRAY with numeric indices, its elements are accessed as $x[0], $x[1], and so on. In GENERAL terms, each element at the position i is accessed and USED as $a[i – 1].

Correct choice is (a) True

To ELABORATE: On Unix the mysql CLIENT WRITES a record of the executed statements to a history file. By DEFAULT, this file is named as ‘.mysql_history’. It is created in the HOME directory.

Correct option is (b) ACCESS Control Lists

The EXPLANATION: MySQL USES security based on Access Control Lists (ACLs) for all CONNECTIONS, queries and other operations that users can attempt to perform. There is support for SSL encrypted connections.

Correct OPTION is (b) -128

The explanation: MySQL supports the SQL standard INTEGER types INTEGER, or INT, and SMALLINT. As an EXTENSION to this standard, MySQL also supports the integer types TINYINT, MEDIUMINT and BIGINT.

Correct answer is (C) STOP SLAVE

Best explanation: The ‘STOP SLAVE’ and ‘START SLAVE’ STATEMENTS SUSPEND and resume the replication-related activity of a slave server. These statements are useful for telling the slave to be quiescent.

The correct choice is (d) REAL

To explain I would SAY: MySQL supports all the standard SQL numeric DATA types. These are the EXACT numeric data types LIKE INTEGER, SMALLINT, DECIMAL and NUMERIC and the approximate numeric data types like FLOAT, REAL and DOUBLE PRECISION.