How is a delimited-text data file reloaded?
1.mysqlexport
2.mysqlimport
3.mysqlexpand
4.mysqltransfer
How is the binary log rotated?
1.FLUSH LOGS
2.ROTATE LOGS
3.FLUSH BINLOG
4.ROTATE BINLOG
How is the output from PHP generated?
1.statically generated
2.dynamically generated
3.not generated
4.no output
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
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
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
In which context is the privilege ‘CREATE TABLESPACE’ applied?
1.Server administration
2.Tables
3.Stored routines
4.Views
In which directory are the DBI scripts located?
1.cgi-inc
2.cgi-bin
3.cgi-usr
4.cgi-perl
MySQL Enterprise Backup records details of each backup in _____
1.history_backup
2.backup_history
3.backlog_history
4.history_backlog
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
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
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
The maximum value that can be specified to the size of VARCHAR is ______
1.0
2.127
3.1023
4.65535
The metadata log is ______
1.error log
2.ddl log
3.binary log
4.relay log
The minimum value stored by signed TINYINT is ______
1.-256
2.-128
3.0
4.128
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
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
The operator used in PHP to access property of an object is _____
1..
2.*
3.->
4.@
The option that suppresses output unless there are errors in the table is _____________
1.–silent
2.–wild
3.–suppress
4.–noout
The program that performs logical backups is _____
1.mysqlimport
2.mysqldump
3.myslqpit
4.mysqllogic
The slave stores the CHANGE MASTER parameters in the file _____
1.slave.info
2.slave.inf
3.master.info
4.master.inf
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
The variable that returns code from operations that return true or false is ________
1.$rc
2.$rv
3.$rows
4.$ary
To use ‘mysqldbcopy’ which privileges are required on the source server?
1.CREATE
2.INSERT
3.UPDATE
4.SELECT
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
What are PHP variables preceded by?
1._
2.@
3.$
4.&
What attempts auto recovery based on the contents of its serial log?
1.MyISAM
2.InnoDB
3.Falcon
4.TRANSACTION
What is the default path to Perl in Unix?
1./usr/bin/perl
2./usr/bin
3./usr/perl
4./usr/perl/bin
What is the default size of ‘max_binlog_cache_size’ system variable?
1.1 GB
2.2 GB
3.4GB
4.8GB
What is the hub of a MySQL installation?
1.mysqla
2.mysqlb
3.mysqlc
4.mysqld
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
What is the output from PHP?
1.statically generated
2.dynamically generated
3.not generated
4.no output
What is the return value from operations returning a row count?
1.$rc
2.$rv
3.$rows
4.$ary
What is the variable that is a handle to a database object?
1.$dbh
2.$sth
3.$fh
4.$h
Where does MySQL Enterprise Backup record details of each backup?
1.history_backup
2.backup_history
3.backlog_history
4.history_backlog
Which data type is best suited to store currency values?
1.INT
2.FLOAT
3.DOUBLE
4.DECIMAL
Which function returns reference to array of row values?
1.fetchrow_array()
2.fetchrow_arrayref()
3.fetch()
4.fetchrow_hashref()
Which function returns reference to hash of row values?
1.fetchrow_array()
2.fetchrow_arrayref()
3.fetch()
4.fetchrow_hashref()
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
Which is the stored program associated with a schedule?
1.Trigger
2.Event
3.Stored function
4.Stored procedure
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
Which of these is not an exact numeric type?
1.SMALLINT
2.DECIMAL
3.NUMERIC
4.REAL
Which operator is used to access property of an object in PHP?
1..
2.*
3.->
4.@
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
Which option suppresses output unless there are errors in the table?
1.–silent
2.–wild
3.–suppress
4.–noout
Which program converts binary log files to statements in text form?
1.mysqldump
2.mysqllog
3.mysqlbin
4.mysqlbinlog
Which program copies the databases from one server to another?
1.mysqldbcopy
2.mysqlcopydb
3.mysqlflushdb
4.mysqldbflush
Which program performs logical backups?
1.mysqlimport
2.mysqldump
3.myslqpit
4.mysqllogic
Which statement on the master expires binary log files?
1.SHOW SLAVE STATUS
2.PURGE MASTER
3.PURGE SLAVE
4.SHOW MASTER STATUS
Which statement suspends the replication related activity of the slave server?
1.RESUME SLAVE
2.START SLAVE
3.STOP SLAVE
4.GET SLAVE