Under which option are index changes not flushed until tables close?

  1. Home
  2. Back

SQL - Online Exam Test Papers | SQL - MCQs[multiple choice questions and answers ] | SQL - Mock Test Papers | SQL - Practice Papers | SQL - Sample Test Papers |

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

More MCQS Questions and answers

  1. How is a delimited-text data file reloaded?
  2. How is the binary log rotated?
  3. How is the output from PHP generated?
  4. If $a represents an array with numeric indices in PHP, the first element accessed by ____
  5. In ‘mysqldump’ which option is used to make all tables in the destination databases to use a different storage engine?
  6. In PHP, how is the first element accessed if $a represents an array with numeric indices?
  7. In which context is the privilege ‘CREATE TABLESPACE’ applied?
  8. In which directory are the DBI scripts located?
  9. MySQL Enterprise Backup records details of each backup in _____
  10. MySQL uses security based on ACL. What does it stand for?
  11. The ‘mysqlbackup’ command to perform a restore operation is ______
  12. The function ‘fetchrow_hashref()’ returns reference to hash of row values keyed by _____
  13. The maximum value that can be specified to the size of VARCHAR is ______
  14. The metadata log is ______
  15. The minimum value stored by signed TINYINT is ______
  16. The mode of search in which the search string is parsed into words and the search looks for rows is ________
  17. The myisamchk variable that represents the size of buffer used to hold index blocks is ______
  18. The operator used in PHP to access property of an object is _____
  19. The option that suppresses output unless there are errors in the table is _____________
  20. The program that performs logical backups is _____
  21. The slave stores the CHANGE MASTER parameters in the file _____
  22. The statement that suspends the replication related activity of the slave server is _____
  23. The variable that returns code from operations that return true or false is ________
  24. To use ‘mysqldbcopy’ which privileges are required on the source server?
  25. Under which option are index changes not flushed until tables close?
  26. What are PHP variables preceded by?
  27. What attempts auto recovery based on the contents of its serial log?
  28. What is the default path to Perl in Unix?
  29. What is the default size of ‘max_binlog_cache_size’ system variable?
  30. What is the hub of a MySQL installation?
  31. What is the log in which data changes received from a replication master server are written?
  32. What is the output from PHP?
  33. What is the return value from operations returning a row count?
  34. What is the variable that is a handle to a database object?
  35. Where does MySQL Enterprise Backup record details of each backup?
  36. Which data type is best suited to store currency values?
  37. Which function returns reference to array of row values?
  38. Which function returns reference to hash of row values?
  39. Which is the log in which data changes received from a replication master server are written?
  40. Which is the stored program associated with a schedule?
  41. Which myisamchk variable represents the size of buffer used to hold index blocks?
  42. Which of these is not an exact numeric type?
  43. Which operator is used to access property of an object in PHP?
  44. Which option is used in ‘mysqldump’ to make all tables in the destination databases to use a different storage engine?
  45. Which option suppresses output unless there are errors in the table?
  46. Which program converts binary log files to statements in text form?
  47. Which program copies the databases from one server to another?
  48. Which program performs logical backups?
  49. Which statement on the master expires binary log files?
  50. Which statement suspends the replication related activity of the slave server?

Question :- How is a delimited-text data file reloaded?

1.mysqlexport

2.mysqlimport

3.mysqlexpand

4.mysqltransfer

Answer 2

Question :- How is the binary log rotated?

1.FLUSH LOGS

2.ROTATE LOGS

3.FLUSH BINLOG

4.ROTATE BINLOG

Answer 1

Question :- How is the output from PHP generated?

1.statically generated

2.dynamically generated

3.not generated

4.no output

Answer 2

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

Answer 2

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

Answer 2

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

Answer 2

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

1.Server administration

2.Tables

3.Stored routines

4.Views

Answer 1

Question :- In which directory are the DBI scripts located?

1.cgi-inc

2.cgi-bin

3.cgi-usr

4.cgi-perl

Answer 2

Question :- MySQL Enterprise Backup records details of each backup in _____

1.history_backup

2.backup_history

3.backlog_history

4.history_backlog

Answer 2

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

Answer 2

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

Answer 1

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

Answer 2

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

1.0

2.127

3.1023

4.65535

Answer 4

Question :- The metadata log is ______

1.error log

2.ddl log

3.binary log

4.relay log

Answer 2

Question :- The minimum value stored by signed TINYINT is ______

1.-256

2.-128

3.0

4.128

Answer 2

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

Answer 2

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

Answer 1

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

1..

2.*

3.->

4.@

Answer 3

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

1.–silent

2.–wild

3.–suppress

4.–noout

Answer 1

Question :- The program that performs logical backups is _____

1.mysqlimport

2.mysqldump

3.myslqpit

4.mysqllogic

Answer 2

Question :- The slave stores the CHANGE MASTER parameters in the file _____

1.slave.info

2.slave.inf

3.master.info

4.master.inf

Answer 3

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

Answer 3

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

1.$rc

2.$rv

3.$rows

4.$ary

Answer 1

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

1.CREATE

2.INSERT

3.UPDATE

4.SELECT

Answer 4

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

Answer 2

Question :- What are PHP variables preceded by?

1._

2.@

3.$

4.&

Answer 3

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

1.MyISAM

2.InnoDB

3.Falcon

4.TRANSACTION

Answer 3

Question :- What is the default path to Perl in Unix?

1./usr/bin/perl

2./usr/bin

3./usr/perl

4./usr/perl/bin

Answer 1

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

1.1 GB

2.2 GB

3.4GB

4.8GB

Answer 3

Question :- What is the hub of a MySQL installation?

1.mysqla

2.mysqlb

3.mysqlc

4.mysqld

Answer 4

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

Answer 4

Question :- What is the output from PHP?

1.statically generated

2.dynamically generated

3.not generated

4.no output

Answer 2

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

1.$rc

2.$rv

3.$rows

4.$ary

Answer 3

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

1.$dbh

2.$sth

3.$fh

4.$h

Answer 1

Question :- Where does MySQL Enterprise Backup record details of each backup?

1.history_backup

2.backup_history

3.backlog_history

4.history_backlog

Answer 2

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

1.INT

2.FLOAT

3.DOUBLE

4.DECIMAL

Answer 4

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

1.fetchrow_array()

2.fetchrow_arrayref()

3.fetch()

4.fetchrow_hashref()

Answer 2

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

1.fetchrow_array()

2.fetchrow_arrayref()

3.fetch()

4.fetchrow_hashref()

Answer 4

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

Answer 4

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

1.Trigger

2.Event

3.Stored function

4.Stored procedure

Answer 2

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

Answer 1

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

1.SMALLINT

2.DECIMAL

3.NUMERIC

4.REAL

Answer 4

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

1..

2.*

3.->

4.@

Answer 3

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

Answer 2

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

1.–silent

2.–wild

3.–suppress

4.–noout

Answer 1

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

1.mysqldump

2.mysqllog

3.mysqlbin

4.mysqlbinlog

Answer 4

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

1.mysqldbcopy

2.mysqlcopydb

3.mysqlflushdb

4.mysqldbflush

Answer 1

Question :- Which program performs logical backups?

1.mysqlimport

2.mysqldump

3.myslqpit

4.mysqllogic

Answer 2

Question :- Which statement on the master expires binary log files?

1.SHOW SLAVE STATUS

2.PURGE MASTER

3.PURGE SLAVE

4.SHOW MASTER STATUS

Answer 2

Question :- Which statement suspends the replication related activity of the slave server?

1.RESUME SLAVE

2.START SLAVE

3.STOP SLAVE

4.GET SLAVE

Answer 3
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!