Question :- How is a delimited-text data file reloaded?

1.mysqlexport

2.mysqlimport

3.mysqlexpand

4.mysqltransfer

Question :- How is the binary log rotated?

1.FLUSH LOGS

2.ROTATE LOGS

3.FLUSH BINLOG

4.ROTATE BINLOG

Question :- How is the output from PHP generated?

1.statically generated

2.dynamically generated

3.not generated

4.no output

Question :- If $a represents an array with numeric indices in PHP, the first element accessed by ____

1.$a[1]

2.$a[0]

3.$a.1

4.$a.0

Question :- In ‘mysqldump’ which option is used to make all tables in the destination databases to use a different storage engine?

1.–next-storage-engine

2.–new-storage-engine

3.–clear-storage-engine

4.–get-storage-engine

Question :- In PHP, how is the first element accessed if $a represents an array with numeric indices?

1.$a[1]

2.$a[0]

3.$a.1

4.$a.0

Question :- In which context is the privilege ‘CREATE TABLESPACE’ applied?

1.Server administration

2.Tables

3.Stored routines

4.Views

Question :- In which directory are the DBI scripts located?

1.cgi-inc

2.cgi-bin

3.cgi-usr

4.cgi-perl

Question :- MySQL Enterprise Backup records details of each backup in _____

1.history_backup

2.backup_history

3.backlog_history

4.history_backlog

Question :- MySQL uses security based on ACL. What does it stand for?

1.Access Control Language

2.Access Control Lists

3.Automatic Control Lists

4.Automatic Control Language

Question :- The ‘mysqlbackup’ command to perform a restore operation is ______

1.copy-back-and-apply-log

2.apply-log-and-copy-back

3.copy-log-and-apply-back

4.apply-back-and-copy-log

Question :- The function ‘fetchrow_hashref()’ returns reference to hash of row values keyed by _____

1.row name

2.column name

3.table name

4.database name

Question :- The maximum value that can be specified to the size of VARCHAR is ______

1.0

2.127

3.1023

4.65535

Question :- The metadata log is ______

1.error log

2.ddl log

3.binary log

4.relay log

Question :- The minimum value stored by signed TINYINT is ______

1.-256

2.-128

3.0

4.128

Question :- The mode of search in which the search string is parsed into words and the search looks for rows is ________

1.Boolean mode

2.Natural language

3.Query expansion

4.Cross mode

Question :- The myisamchk variable that represents the size of buffer used to hold index blocks is ______

1.key_buffer_size

2.read_buffer_size

3.sort_buffer_size

4.write_buffer_size

Question :- The operator used in PHP to access property of an object is _____

1..

2.*

3.->

4.@

Question :- The option that suppresses output unless there are errors in the table is _____________

1.–silent

2.–wild

3.–suppress

4.–noout

Question :- The program that performs logical backups is _____

1.mysqlimport

2.mysqldump

3.myslqpit

4.mysqllogic

Question :- The slave stores the CHANGE MASTER parameters in the file _____

1.slave.info

2.slave.inf

3.master.info

4.master.inf

Question :- The statement that suspends the replication related activity of the slave server is _____

1.RESUME SLAVE

2.START SLAVE

3.STOP SLAVE

4.GET SLAVE

Question :- The variable that returns code from operations that return true or false is ________

1.$rc

2.$rv

3.$rows

4.$ary

Question :- To use ‘mysqldbcopy’ which privileges are required on the source server?

1.CREATE

2.INSERT

3.UPDATE

4.SELECT

Question :- Under which option are index changes not flushed until tables close?

1.–delay-write-key

2.–delay-key-write

3.–write-key-delay

4.–key-write-delay

Question :- What are PHP variables preceded by?

1._

2.@

3.$

4.&

Question :- What attempts auto recovery based on the contents of its serial log?

1.MyISAM

2.InnoDB

3.Falcon

4.TRANSACTION

Question :- What is the default path to Perl in Unix?

1./usr/bin/perl

2./usr/bin

3./usr/perl

4./usr/perl/bin

Question :- What is the default size of ‘max_binlog_cache_size’ system variable?

1.1 GB

2.2 GB

3.4GB

4.8GB

Question :- What is the hub of a MySQL installation?

1.mysqla

2.mysqlb

3.mysqlc

4.mysqld

Question :- What is the log in which data changes received from a replication master server are written?

1.error log

2.general query log

3.binary log

4.relay log

Question :- What is the output from PHP?

1.statically generated

2.dynamically generated

3.not generated

4.no output

Question :- What is the return value from operations returning a row count?

1.$rc

2.$rv

3.$rows

4.$ary

Question :- What is the variable that is a handle to a database object?

1.$dbh

2.$sth

3.$fh

4.$h

Question :- Where does MySQL Enterprise Backup record details of each backup?

1.history_backup

2.backup_history

3.backlog_history

4.history_backlog

Question :- Which data type is best suited to store currency values?

1.INT

2.FLOAT

3.DOUBLE

4.DECIMAL

Question :- Which function returns reference to array of row values?

1.fetchrow_array()

2.fetchrow_arrayref()

3.fetch()

4.fetchrow_hashref()

Question :- Which function returns reference to hash of row values?

1.fetchrow_array()

2.fetchrow_arrayref()

3.fetch()

4.fetchrow_hashref()

Question :- Which is the log in which data changes received from a replication master server are written?

1.error log

2.general query log

3.binary log

4.relay log

Question :- Which is the stored program associated with a schedule?

1.Trigger

2.Event

3.Stored function

4.Stored procedure

Question :- Which myisamchk variable represents the size of buffer used to hold index blocks?

1.key_buffer_size

2.read_buffer_size

3.sort_buffer_size

4.write_buffer_size

Question :- Which of these is not an exact numeric type?

1.SMALLINT

2.DECIMAL

3.NUMERIC

4.REAL

Question :- Which operator is used to access property of an object in PHP?

1..

2.*

3.->

4.@

Question :- Which option is used in ‘mysqldump’ to make all tables in the destination databases to use a different storage engine?

1.–next-storage-engine

2.–new-storage-engine

3._clear-storage-engine

4._get-storage-engine

Question :- Which option suppresses output unless there are errors in the table?

1.–silent

2.–wild

3.–suppress

4.–noout

Question :- Which program converts binary log files to statements in text form?

1.mysqldump

2.mysqllog

3.mysqlbin

4.mysqlbinlog

Question :- Which program copies the databases from one server to another?

1.mysqldbcopy

2.mysqlcopydb

3.mysqlflushdb

4.mysqldbflush

Question :- Which program performs logical backups?

1.mysqlimport

2.mysqldump

3.myslqpit

4.mysqllogic

Question :- Which statement on the master expires binary log files?

1.SHOW SLAVE STATUS

2.PURGE MASTER

3.PURGE SLAVE

4.SHOW MASTER STATUS

Question :- Which statement suspends the replication related activity of the slave server?

1.RESUME SLAVE

2.START SLAVE

3.STOP SLAVE

4.GET SLAVE