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

Posted Date:-2021-07-18 21:16:19


Question:
How is the binary log rotated?

1.FLUSH LOGS

2.ROTATE LOGS

3.FLUSH BINLOG

4.ROTATE BINLOG

Posted Date:-2021-07-18 21:16:19


Question:
How is the output from PHP generated?

1.statically generated

2.dynamically generated

3.not generated

4.no output

Posted Date:-2021-07-18 21:16:19


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

Posted Date:-2021-07-18 21:16:19


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

Posted Date:-2021-07-18 21:16:19


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

Posted Date:-2021-07-18 21:16:19


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

1.Server administration

2.Tables

3.Stored routines

4.Views

Posted Date:-2021-07-18 21:16:19


Question:
In which directory are the DBI scripts located?

1.cgi-inc

2.cgi-bin

3.cgi-usr

4.cgi-perl

Posted Date:-2021-07-18 21:16:19


Question:
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-18 21:16:19


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

Posted Date:-2021-07-18 21:16:19


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

Posted Date:-2021-07-18 21:16:19


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

Posted Date:-2021-07-18 21:16:19


Question:
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-18 21:16:19


Question:
The metadata log is ______

1.error log

2.ddl log

3.binary log

4.relay log

Posted Date:-2021-07-18 21:16:19


Question:
The minimum value stored by signed TINYINT is ______

1.-256

2.-128

3.0

4.128

Posted Date:-2021-07-18 21:16:19


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

Posted Date:-2021-07-18 21:16:19


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

Posted Date:-2021-07-18 21:16:19


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

1..

2.*

3.->

4.@

Posted Date:-2021-07-18 21:16:19


Question:
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-18 21:16:19


Question:
The program that performs logical backups is _____

1.mysqlimport

2.mysqldump

3.myslqpit

4.mysqllogic

Posted Date:-2021-07-18 21:16:19


Question:
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-18 21:16:19


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

Posted Date:-2021-07-18 21:16:19


Question:
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-18 21:16:19


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

1.CREATE

2.INSERT

3.UPDATE

4.SELECT

Posted Date:-2021-07-18 21:16:19


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

Posted Date:-2021-07-18 21:16:19


Question:
What are PHP variables preceded by?

1._

2.@

3.$

4.&

Posted Date:-2021-07-18 21:16:19


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

1.MyISAM

2.InnoDB

3.Falcon

4.TRANSACTION

Posted Date:-2021-07-18 21:16:19


Question:
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-18 21:16:19


Question:
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-18 21:16:19


Question:
What is the hub of a MySQL installation?

1.mysqla

2.mysqlb

3.mysqlc

4.mysqld

Posted Date:-2021-07-18 21:16:19


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

Posted Date:-2021-07-18 21:16:19


Question:
What is the output from PHP?

1.statically generated

2.dynamically generated

3.not generated

4.no output

Posted Date:-2021-07-18 21:16:19


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

1.$rc

2.$rv

3.$rows

4.$ary

Posted Date:-2021-07-18 21:16:19


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

1.$dbh

2.$sth

3.$fh

4.$h

Posted Date:-2021-07-18 21:16:19


Question:
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-18 21:16:19


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

1.INT

2.FLOAT

3.DOUBLE

4.DECIMAL

Posted Date:-2021-07-18 21:16:19


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

1.fetchrow_array()

2.fetchrow_arrayref()

3.fetch()

4.fetchrow_hashref()

Posted Date:-2021-07-18 21:16:19


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

1.fetchrow_array()

2.fetchrow_arrayref()

3.fetch()

4.fetchrow_hashref()

Posted Date:-2021-07-18 21:16:19


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

Posted Date:-2021-07-18 21:16:19


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

1.Trigger

2.Event

3.Stored function

4.Stored procedure

Posted Date:-2021-07-18 21:16:19


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

Posted Date:-2021-07-18 21:16:19


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

1.SMALLINT

2.DECIMAL

3.NUMERIC

4.REAL

Posted Date:-2021-07-18 21:16:19


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

1..

2.*

3.->

4.@

Posted Date:-2021-07-18 21:16:19


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

Posted Date:-2021-07-18 21:16:19


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

1.–silent

2.–wild

3.–suppress

4.–noout

Posted Date:-2021-07-18 21:16:19


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

1.mysqldump

2.mysqllog

3.mysqlbin

4.mysqlbinlog

Posted Date:-2021-07-18 21:16:19


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

1.mysqldbcopy

2.mysqlcopydb

3.mysqlflushdb

4.mysqldbflush

Posted Date:-2021-07-18 21:16:19


Question:
Which program performs logical backups?

1.mysqlimport

2.mysqldump

3.myslqpit

4.mysqllogic

Posted Date:-2021-07-18 21:16:19


Question:
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-18 21:16:19


Question:
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-18 21:16:19


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!