Explore topic-wise InterviewSolutions in .

Correct CHOICE is (a) mysql_real_query()

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

Correct answer is (a) my_global.h

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 (a) Statement based

For explanation: There are two main kinds of replication format: Statement Based Replication (SBR) REPLICATES entire SQL STATEMENTS and Row Based Replication (RBR) replicates only the changed rows.

Right choice is (a) True

The best I can explain: Replication enables DATA from one MySQL DATABASE server (the MASTER) to be COPIED to one or more MySQL database servers (the slaves). Replication is asynchronous by default.

Right 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.

Right 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 choice is (B) -o

Easy explanation: When a C program is COMPILED with gcc, the option -o is issued in order to specify the name of the executable that is CREATED after COMPILATION. The default name given is ‘a.out’.

The correct choice is (a) -LM

Explanation: To compile a program WRITTEN in the C LANGUAGE, it is COMPILED by issuing the option ‘-lm’. The examples of some math functions found in ‘math.h’ are FLOOR(), sqrt(), pow(), log().

The correct choice is (d) C

For explanation: It is not as EASY to perform TEXT processing and memory management in C than it is in languages LIKE PERL and PHP. These capabilities tend to be heavily USED in web applications.

The correct ANSWER is (a) C

The EXPLANATION: In order to provide application DEVELOPMENT, MySQL provides a client library WRITTEN in the C programming language. It ENABLES access to MySQL databases from a C program.

Right answer is (a) Server administration

The best I can explain: The column name associated with the privilege ‘CREATE TABLESPACE’ is ‘Create_tablespace_priv’. The context in which this privilege is being USED is the server administration.

The correct option is (a) True

To EXPLAIN: In the MYSQL privilege system, a PASSWORD applies globally to an account. A password cannot be explicitly associated with a specific object such as a database, table, or ROUTINE.

Right option is (a) True

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

The correct choice is (b) ACCESS Control Lists

Easiest 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.

Right choice is (a) mysqldump

Best explanation: In MYSQL, some DISTRIBUTIONS INCLUDE a SET of some CLIENT programs. ‘mysqldump’ exports the table definitions and the contents. ‘mysqladmin’ performs adminisitrative tasks.

The CORRECT choice is (a) table_cache

The explanation is: In MYSQL, when the server OPENS table files it keeps them open to minimize the number of file-opening operations. It maintains INFORMATION about open files in the table CACHE.

The correct option is (c) 4 GB

Easy explanation: The max_binlog_cache_size system variable can be USED to restrict the total size used to cache a multiple-statement transaction. If transaction is larger than this it FAILS and ROLLS BACK.

Right answer is (b) ddl LOG

The best explanation: The DDL log is also known as the metadata log. The metadata operations PERFORMED by the DDL statements. The RELAY Log has the data CHANGES received from a replication master server WRITTEN in it.

Right answer is (d) relay log

The EXPLANATION is: The Relay Log has the DATA changes received from a replication master SERVER written in it. The problems encountered during the starting, running or stopping of ‘mysqld’ are written in error log.

Correct choice is (a) True

Explanation: It is useful to run multiple SERVERS on the same MACHINE under certain CIRCUMSTANCES. A NEW MySQL release can also be tested while leaving the CURRENT production server in place.

Correct ANSWER is (a) True

Explanation: The MYSQL server is highly configurable. Some of the operational characteristics that you can control include which STORAGE engines the server supports, the DEFAULT character set, and its default time zone.

The correct CHOICE is (B) more efficient

The explanation is: LOAD DATA is more efficient without LOCAL. Without LOCAL, the file must be located on the server. The FILE privilege must be given. The server can READ the file DIRECTLY from disk.

The CORRECT choice is (a) INET_ATON()

The best I can explain: In MYSQL, the function USED to CONVERT a string to an INTEGER is INET_ATON(). On the other hand, the function INET_NTOA() converts a string to the corresponding integer value.

Correct CHOICE is (B) INET_NTOA()

To elaborate: In MySQL, the function used to convert an integer to a string is INET_NTOA(). On the other hand, the function INET_ATON() CONVERTS a string to the CORRESPONDING integer VALUE.

Right option is (b) ANALYZE TABLE

Explanation: In MySQL, for the MYISAM and INNODB tables, the server can be told to PERFORM an analysis of key values by ISSUING the ANALYZE TABLE STATEMENT. It helps in knowing about query optimization.

Correct choice is (d) EXPLAIN

The explanation: In MySQL, by issuing an EXPLAIN STATEMENT MySQL displays some INFORMATION about how it would EXECUTE a SELECT query without actually EXECUTING it. It is prefixed with the query.

Correct answer is (C) mysqlhotcopy

The BEST explanation: ‘MYSQLDUMP’ and ‘mysqlhotcopy’ are the tools or programs that are used for performing the backing up of the DATABASES and copying databases from ONE server to the other server(s).

Right OPTION is (a) True

Explanation: The MySQL data directory is the PLACE where the SERVER stores its DATABASES and status files. It is crucial to understand that all the STRUCTURES and contents of the data directory.

Right choice is (d) mysqld

Explanation: The server, mysqld, is the hub of a MYSQL installation; it performs all MANIPULATION of databases and TABLES. On Unix, several related SCRIPTS are AVAILABLE to assist in server startup.