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