Explore topic-wise InterviewSolutions in .

Right choice is (B) Event

To explain: The MySQL version 5.1.6 and above has an event scheduler. It enables us to perform time activated database operations. An event is a STORED program that is ASSOCIATED with a schedule.

The correct choice is (b) cgi-bin

For explanation: DBI SCRIPTS are located in a cgi-bin directory located OUTSIDE of DOCUMENT TREE. The PHP scripts are different from DBI scripts since PHP scripts are located within the WEB server document tree.

Correct answer is (a) Server ADMINISTRATION

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

Right OPTION is (B) backup_history

The best explanation: The restored data includes the ‘backup_history’ table, where ‘MySQL Enterprise Backup’ records DETAILS of each backup. The table ALLOWS to perform future incremental backups using ‘–incremental-base=history:last_backup’.

Right CHOICE is (B) PURGE MASTER

For explanation I would say: The ‘PURGE MASTER’ statement on the master expires binary log files. This can be used after ISSUING a ‘SHOW SLAVE STATUS’ statement on each of the slaves to determine which log files are no longer needed.

Right option is (c) MASTER.info

Explanation: The ‘slave’ stores the ‘CHANGE MASTER’ PARAMETERS in a file named ‘master.info’ in its data directory in order to RECORD the initial replication status. It updates the file as replication PROCEEDS.

Right option is (c) 4 GB

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

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

Correct OPTION is (b) False

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

Correct OPTION is (a) key_buffer_size

Easiest explanation: The myisamchk variable ‘key_buffer_size’ stores the size of buffer that is USED to hold index BLOCKS. ‘read_buffer_size’ stores size of buffer used for read OPERATIONS, ‘sort_buffer_size’ is used for SORTING.

Correct option is (a) copy-back-and-apply-log

Easiest explanation: The ‘mysqlbackup’ commands to PERFORM a restore OPERATION are ‘copy-back-and-apply-log’ and ‘copy-back’ (for directory backup only). The restoration process REQUIRES the database server to be already SHUT down.

Right option is (d) mysqlbinlog

Explanation: The ‘mysqlbinlog’ PROGRAM is USED to convert the binary log files to statements in text form. This MAKES it EASY to execute. The output from ‘mysqlbinlog’ is used as input to mysql.

Correct answer is (d) DECIMAL

Explanation: Currency is a numeric information. For MONETARY calculations, FLOAT and DOUBLE are subject to rounding error and MAY not be suitable. A DECIMAL(M, 2) TYPE is best suited for it.

Right choice is (C) $

The explanation: All the PHP scripts that use variables have VARIABLE NAMES preceded by the dollar sign (‘$’). The variables are signified by this identifier, IRRESPECTIVE of the value it STORES.

Correct option is (B) dynamically generated

To explain: The INTERPRETER switches between code mode back and text mode when it sees another special TAG that signals the end of the code. This ENABLES the mix of STATIC text with dynamically generated results.

Correct CHOICE is (b) False

To explain: The MySQL data directory is the PLACE where the server stores its databases and status files. It is crucial to UNDERSTAND all structures and CONTENTS of the data directory.

Correct OPTION is (b) –new-storage-engine

The BEST I can explain: While using the program ‘mysqldump’ in MySQL to copy databases from SERVER to server, all tables in the destination databases can be directed to USE a DIFFERENT storage engine with the –new-storage-engine option.

The CORRECT choice is (a) key_buffer_size

Easy EXPLANATION: The myisamchk variable ‘key_buffer_size’ STORES the size of buffer that is used to hold index blocks. ‘read_buffer_size’ stores the size of buffer used for read operations, ‘sort_buffer_size’ is used for SORTING.

Right ANSWER is (d) relay log

Explanation: 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’ is written in error log.

Correct answer is (b) False

Easy 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 choice is (b) False

The best 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.

Right choice is (b) fetchrow_arrayref()

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

Correct ANSWER is (d) fetchrow_hashref()

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().

The CORRECT answer is (b) –new-STORAGE-engine

For explanation: While using the PROGRAM ‘MYSQLDUMP’ in MySQL to copy databases from server to server, all tables in the destination databases can be directed to use a DIFFERENT storage engine with the –new-storage-engine option.

The correct choice is (b) mysqldump

The best I can explain: The ‘mysqldump’ PERFORMS LOGICAL BACKUPS. It PRODUCES a set of SQL statements that are executed to reproduce the original database OBJECT definitions. It dumps one or more MySQL databases for backup.

Right choice is (d) SELECT

The best explanation: To use the UTILITY program ‘mysqldbcopy’, the USER MUST have SELECT privileges for the DATABASE(s) on the source server and have CREATE, INSERT, UPDATE on the DESTINATION server.

Correct answer is (a) mysqldbcopy

Best explanation: The utility program ‘mysqldbcopy’ is CAPABLE of COPYING databases from one server to another server. It can ALSO prepare copies to MAKE transfers on the same servers. This can be done simply by running the program.

Right choice is (a) True

To explain I would say: The MySQL data directory is the place where the server STORES its DATABASES and status files. It is crucial to UNDERSTAND all the structures and CONTENTS of the data directory.

Correct option is (d) mysqld

The best I can explain: 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.

Correct choice is (b) NATURAL language

The best I can explain: In MySQL, a full text SEARCH CAPABILITY is provided, which enables to LOOK for words or phrases without using pattern-matching operations. There are THREE kinds of full text searches.

The correct option is (a) True

To explain I would say: While USING 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”.

Correct answer is (c) $rows

Easy explanation: The Perl Non-handle variable ‘$ary’ is an array or list REPRESENTING a row of values returned by a query. ‘$rc’ returns code from operations that RETURN TRUE or false. ‘$rv’ returns value from operations that return an integer. ‘$rows’ returns value from operations that return a row COUNT.

Right option is (a) –silent

The best EXPLANATION: In MySQL, the ‘–silent’ option suppresses the output UNLESS there are errors in the tables. The ‘cron’ JOBS typically generate a mail message if a JOB PRODUCES any output at all.

Correct option is (b) MYSQLDUMP

The explanation is: The ‘mysqldump’ performs logical backups. It produces a set of SQL statements that are executed to reproduce the ORIGINAL database object DEFINITIONS. It dumps one or more MYSQL databases for backup.

Correct answer is (b) mysqlimport

To elaborate: In ORDER to reload a delimited-text data file, use ‘LOAD DATA INFILE’ or ‘mysqlimport’. MYSQL supports the incremental backups when the server is STARTED with the ‘–log-bin’ OPTION.

The correct answer is (a) FLUSH LOGS

Easy EXPLANATION: MYSQL supports incremental backups. The SERVER should be started with the ‘–log-bin’ option to enable BINARY logging. The binary log files provide information to replicate CHANGES to the database.

Correct CHOICE is (c) ->

EASY explanation: If $a represents an object, the properties it has can be ACCESSED as $a->property-name. For INSTANCE, $a->WHITE, $a->black, $a->blue, $a->red can be the properties of $a and accessed in this way.

The correct CHOICE is (a) True

The explanation is: The PHP ARRAYS can even have both numeric and associative elements. For example, $x[1] and $x[“large”] can both be the elements of the same array. $x can be an object, whose elements are ACCESSED by the arrow ‘->’ OPERATED.

The correct OPTION is (a) $dbh

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

Correct CHOICE is (a) –silent

Best EXPLANATION: In MySQL, the ‘–silent’ option suppresses the output unless there are errors in the tables. The ‘CRON’ jobs typically generate a mail MESSAGE if a job PRODUCES any output at all.

Right choice is (b) –delay-key-write

For explanation I would say: In MYSQL, the MyISAM recovery is IMPORTANT if the server is RUN with the ‘–delay-key-write’ option. Under this CONDITION, the INDEX changes are not flushed until the tables close.

Right CHOICE is (c) Falcon

Easiest explanation: When the Falcon storage engine is ENABLED, it attempts the auto recovery BASED on the contents of its serial log. If the INNODB storage engine is enabled, it checks for a variety of problems AUTOMATICALLY.