SQL/SQL MCQ SET 9 Sample Test,Sample questions

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


More MCQS

  1. SQL MCQ SET 1
  2. SQL MCQ SET 2
  3. SQL MCQ SET 3
  4. SQL MCQ SET 4
  5. SQL MCQ SET 5
  6. SQL MCQ SET 6
  7. SQL MCQ SET 7
  8. SQL MCQ SET 8
  9. SQL MCQ SET 9
  10. SQL MCQ SET 10
  11. SQL MCQ SET 11
  12. SQL MCQ SET 12
  13. SQL MCQ SET 13
  14. SQL MCQ SET 14
  15. SQL MCQ SET 15
  16. SQL MCQ SET 16
  17. SQL MCQ SET 17
  18. SQL MCQ SET 18
  19. MCQ | SQL – Basics
  20. MCQ | SQL – Data Types
  21. SQL Server DBA Multiple Choice Questions
Search
R4R Team
R4Rin Top Tutorials are Core Java,Hibernate ,Spring,Sturts.The content on R4R.in website is done by expert team not only with the help of books but along with the strong professional knowledge in all context like coding,designing, marketing,etc!