R4RIN – MCQs, Mock Tests | SQL SQL MCQ SET 9

What is the default path to Perl in Unix?

1. /usr/bin/perl
2. /usr/bin
3. /usr/perl
4. /usr/perl/bin

✅ Correct Answer: 1

How is the output from PHP generated?

1. statically generated
2. dynamically generated
3. not generated
4. no output

✅ Correct Answer: 2

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

1. MyISAM
2. InnoDB
3. Falcon
4. TRANSACTION

✅ Correct Answer: 3

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

✅ Correct Answer: 2

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

1. –silent
2. –wild
3. –suppress
4. –noout

✅ Correct Answer: 1

What is the variable that is a handle to a database object?

1. $dbh
2. $sth
3. $fh
4. $h

✅ Correct Answer: 1

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

1. $rc
2. $rv
3. $rows
4. $ary

✅ Correct Answer: 1

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

✅ Correct Answer: 2

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

1. .
2. *
3. ->
4. @

✅ Correct Answer: 3

How is the binary log rotated?

1. FLUSH LOGS
2. ROTATE LOGS
3. FLUSH BINLOG
4. ROTATE BINLOG

✅ Correct Answer: 1

How is a delimited-text data file reloaded?

1. mysqlexport
2. mysqlimport
3. mysqlexpand
4. mysqltransfer

✅ Correct Answer: 2

Which program performs logical backups?

1. mysqlimport
2. mysqldump
3. myslqpit
4. mysqllogic

✅ Correct Answer: 2

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

1. –silent
2. –wild
3. –suppress
4. –noout

✅ Correct Answer: 1

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

1. $rc
2. $rv
3. $rows
4. $ary

✅ Correct Answer: 3

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

✅ Correct Answer: 2

What is the hub of a MySQL installation?

1. mysqla
2. mysqlb
3. mysqlc
4. mysqld

✅ Correct Answer: 4

Which program copies the databases from one server to another?

1. mysqldbcopy
2. mysqlcopydb
3. mysqlflushdb
4. mysqldbflush

✅ Correct Answer: 1

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

1. CREATE
2. INSERT
3. UPDATE
4. SELECT

✅ Correct Answer: 4

The program that performs logical backups is _____

1. mysqlimport
2. mysqldump
3. myslqpit
4. mysqllogic

✅ Correct Answer: 2

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

✅ Correct Answer: 2

Which function returns reference to hash of row values?

1. fetchrow_array()
2. fetchrow_arrayref()
3. fetch()
4. fetchrow_hashref()

✅ Correct Answer: 4

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

✅ Correct Answer: 2

Which function returns reference to array of row values?

1. fetchrow_array()
2. fetchrow_arrayref()
3. fetch()
4. fetchrow_hashref()

✅ Correct Answer: 2

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

✅ Correct Answer: 4

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

✅ Correct Answer: 1

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

✅ Correct Answer: 2

What is the output from PHP?

1. statically generated
2. dynamically generated
3. not generated
4. no output

✅ Correct Answer: 2

What are PHP variables preceded by?

1. _
2. @
3. $
4. &

✅ Correct Answer: 3

Which data type is best suited to store currency values?

1. INT
2. FLOAT
3. DOUBLE
4. DECIMAL

✅ Correct Answer: 4

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

1. mysqldump
2. mysqllog
3. mysqlbin
4. mysqlbinlog

✅ Correct Answer: 4

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

✅ Correct Answer: 1

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

✅ Correct Answer: 1

Where does MySQL Enterprise Backup record details of each backup?

1. history_backup
2. backup_history
3. backlog_history
4. history_backlog

✅ Correct Answer: 2

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

✅ Correct Answer: 4

The metadata log is ______

1. error log
2. ddl log
3. binary log
4. relay log

✅ Correct Answer: 2

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

1. 1 GB
2. 2 GB
3. 4GB
4. 8GB

✅ Correct Answer: 3

The slave stores the CHANGE MASTER parameters in the file _____

1. slave.info
2. slave.inf
3. master.info
4. master.inf

✅ Correct Answer: 3

Which statement on the master expires binary log files?

1. SHOW SLAVE STATUS
2. PURGE MASTER
3. PURGE SLAVE
4. SHOW MASTER STATUS

✅ Correct Answer: 2

Which statement suspends the replication related activity of the slave server?

1. RESUME SLAVE
2. START SLAVE
3. STOP SLAVE
4. GET SLAVE

✅ Correct Answer: 3

MySQL Enterprise Backup records details of each backup in _____

1. history_backup
2. backup_history
3. backlog_history
4. history_backlog

✅ Correct Answer: 2

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

1. Server administration
2. Tables
3. Stored routines
4. Views

✅ Correct Answer: 1

In which directory are the DBI scripts located?

1. cgi-inc
2. cgi-bin
3. cgi-usr
4. cgi-perl

✅ Correct Answer: 2

Which is the stored program associated with a schedule?

1. Trigger
2. Event
3. Stored function
4. Stored procedure

✅ Correct Answer: 2

Which of these is not an exact numeric type?

1. SMALLINT
2. DECIMAL
3. NUMERIC
4. REAL

✅ Correct Answer: 4

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

✅ Correct Answer: 3

The minimum value stored by signed TINYINT is ______

1. -256
2. -128
3. 0
4. 128

✅ Correct Answer: 2

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

✅ Correct Answer: 2

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

✅ Correct Answer: 2

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

1. .
2. *
3. ->
4. @

✅ Correct Answer: 3

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

1. 0
2. 127
3. 1023
4. 65535

✅ Correct Answer: 4