SQL/SQL MCQ SET 7 Sample Test,Sample questions

Question:
For what can the FULLTEXT indexes be created for?

1.MyISAM

2.InnoDB

3.MEMORY

4.TRANSITION

Posted Date:-2021-07-18 21:14:50


Question:
For which of these storage engines are configuration options always built?

1.Falcon

2.FEDERATED

3.InnoDB

4.MyISAM

Posted Date:-2021-07-18 21:14:50


Question:
How can a view refer to multiple tables?

1.UNION

2.JOIN

3.GROUP

4.SELECT

Posted Date:-2021-07-18 21:14:50


Question:
How many digits is the DECIMAL used for expressions containing only exact values with fractional part?

1.32

2.64

3.65

4.16

Posted Date:-2021-07-18 21:14:50


Question:
How many options can be used to control LOCAL capability at runtime?

1.0

2.1

3.2

4.3

Posted Date:-2021-07-18 21:14:50


Question:
If an error occurs during the transaction the troubleshoot is ______

1.delete

2.rollback

3.commit

4.update

Posted Date:-2021-07-18 21:14:50


Question:
In which table of INFORMATION_SCHEMA is the information about table index characteristics stored?

1.FILES

2.STATISTICS

3.SCHEMATA

4.VIEWS

Posted Date:-2021-07-18 21:14:50


Question:
Increasing the value of which system variable enables mysqld to keep more tables open simultaneously?

1.table_cache

2.max_connect

3.delayed_queue_size

4.max_allowed_packet

Posted Date:-2021-07-18 21:14:50


Question:
The ALL subquery performs operations on _____________

1.row

2.column

3.table

4.database

Posted Date:-2021-07-18 21:14:50


Question:
The ALL subquery performs the operation ______

1.row

2.column

3.table

4.database

Posted Date:-2021-07-18 21:14:50


Question:
The ‘A’ in the ACID property of transactions is _____

1.Availability

2.Accuracy

3.Adjustability

4.Atomicity

Posted Date:-2021-07-18 21:14:50


Question:
The ‘C’ in the ACID property of transactions is ____

1.Compound

2.Concrete

3.Collision

4.Consistency

Posted Date:-2021-07-18 21:14:50


Question:
The datatype that means a variable length non binary string is _____

1.VARCHAR

2.BINARY

3.VARBINARY

4.BLOB

Posted Date:-2021-07-18 21:14:50


Question:
The date and time datatype that stores time value in ‘hh:mm:ss’ format is ______

1.DATE

2.TIME

3.DATETIME

4.TIMESTAMP

Posted Date:-2021-07-18 21:14:50


Question:
The default value in seconds in the system variable ‘long_query_time’ is ______

1.5

2.10

3.20

4.60

Posted Date:-2021-07-18 21:14:50


Question:
The grant table that stores users who can connect to the server and their global privileges are ______

1.user

2.db

3.tables_priv

4.procs_priv

Posted Date:-2021-07-18 21:14:50


Question:
The keyword used with UNION that does not retain duplicate rows is _______

1.ALL

2.NARROW

3.STRICT

4.DISTINCT

Posted Date:-2021-07-18 21:14:50


Question:
The keyword used with UNION that retains duplicate rows is ________

1.ALL

2.NARROW

3.STRICT

4.DISTINCT

Posted Date:-2021-07-18 21:14:50


Question:
The keyword used with UNION that retains duplicate rows is ___________

1.ALL

2.NARROW

3.STRICT

4.DISTINCT

Posted Date:-2021-07-18 21:14:50


Question:
The largest value to which the variable ‘max_allowed_packet’ can be set is _______

1.1GB

2.2GB

3.4GB

4.8GB

Posted Date:-2021-07-18 21:14:50


Question:
The LOCAL capability for client library is enabled by _______

1._enabled-local-file

2._enable-local-infile

3._enable-global-file

4._enable-local-file

Posted Date:-2021-07-18 21:14:50


Question:
The log that contains a record of server startups and shutdowns and the messages about exceptional conditions is ______

1.error log

2.general query

3.slow query log

4.binary log

Posted Date:-2021-07-18 21:14:50


Question:
The log that identifies statements that may be in need of being rewritten for better performance is ________

1.error log

2.general query

3.slow query log

4.binary log

Posted Date:-2021-07-18 21:14:50


Question:
The logging option to enable binary log index file is _______

1._log-bin-index

2._bin-log-index

3._index-log-bin

4._index-bin-log

Posted Date:-2021-07-18 21:14:50


Question:
The mode used to turn off the special meaning of backslash and treat it as an ordinary character is ______

1.NO_ESCAPES_SLASH

2.NO_ESCAPES_BACKSLASH

3.NO_BACKSLASH_ESCAPES

4.NO_BACKSLASH_ESCAPE

Posted Date:-2021-07-18 21:14:50


Question:
The most important configurable resource for MyISAM is _____

1.key cache

2.memory cache

3.time cache

4.speed cache

Posted Date:-2021-07-18 21:14:50


Question:
The number of options that can be used to control LOCAL capability at runtime is _____

1.0

2.1

3.2

4.3

Posted Date:-2021-07-18 21:14:50


Question:
The operators that are used when a subquery returns multiple rows to be evaluated in comparison to the outer query are ____________

1.IN and NOT IN

2.EXISTS and NOT EXISTS

3.OUTER JOIN and INNER JOIN

4.LEFT JOIN and RIGHT JOIN

Posted Date:-2021-07-18 21:14:50


Question:
The operators used when a subquery returns multiple rows to be evaluated in comparison to the outer query are _______

1.IN and NOT IN

2.EXISTS and NOT EXISTS

3.OUTER JOIN and INNER JOIN

4.LEFT JOIN and RIGHT JOIN

Posted Date:-2021-07-18 21:14:50


Question:
The option that supplies the pathname to root directory of MySQL installation is _______

1.–basedir

2.–datadir

3.–port

4.–socket

Posted Date:-2021-07-18 21:14:50


Question:
The search mode that uses natural language search as a subroutine is ________

1.Natural language

2.Boolean mode

3.Query expansion

4.Cross mode

Posted Date:-2021-07-18 21:14:50


Question:
The spatial datatype used to store a curve is _______

1.GEOMETRY

2.POINT

3.LINESTRING

4.POLYGON

Posted Date:-2021-07-18 21:14:50


Question:
The statement used to obtain access privileges to an account is _______

1.OBTAIN

2.GET

3.GRANT

4.NEED

Posted Date:-2021-07-18 21:14:50


Question:
The storage engine for which the runtime options are always enabled is ______

1.Falcon

2.FEDERATED

3.InnoDB

4.MEMORY

Posted Date:-2021-07-18 21:14:50


Question:
The storage engine in MySQL that provides foreign key support is ___________

1.TRANSACTION

2.InnoDB

3.MyISAM

4.MEMORY

Posted Date:-2021-07-18 21:14:50


Question:
The stored-routine privileges are contained in _______

1.user

2.db

3.tables_priv

4.procs_priv

Posted Date:-2021-07-18 21:14:50


Question:
The variable which represents the default time zone of the MySQL server is _______

1.time_zone

2.system_time_zone

3.date_and_time

4.system_time

Posted Date:-2021-07-18 21:14:50


Question:
What are CROSS JOIN and JOIN are similar to?

1.INNER JOIN

2.NATURAL JOIN

3.OUTER JOIN

4.CARTESIAN JOIN

Posted Date:-2021-07-18 21:14:50


Question:
What are X’61626364′ and X’61626364′?

1.abcd and 1633837924

2.abcd and 4297383361

3.dcba and 1633837924

4.dcba and 4297383361

Posted Date:-2021-07-18 21:14:50


Question:
What is the clause that filters JOIN results called?

1.WHERE

2.SORT

3.GROUP

4.GROUP BY

Posted Date:-2021-07-18 21:14:50


Question:
What is the join where all possible row combinations are produced?

1.INNER JOIN

2.OUTER

3.NATURAL

4.CARTESIAN

Posted Date:-2021-07-18 21:14:50


Question:
What is the kind of delete when deletion of an employee from the table also deletes that employee from another table?

1.transparent

2.concrete

3.elaborate

4.cascaded

Posted Date:-2021-07-18 21:14:50


Question:
What is the mantissa in -1.58E5?

1.-1.58

2.1.58

3.E

4.5

Posted Date:-2021-07-18 21:14:50


Question:
What is the most important configurable resource for MyISAM?

1.key cache

2.memory cache

3.time cache

4.speed cache

Posted Date:-2021-07-18 21:14:50


Question:
What is the precision of BIGINT?

1.32

2.64

3.128

4.16

Posted Date:-2021-07-18 21:14:50


Question:
What is the property of InnoDB that enforces foreign key relationships stay intact?

1.atomicity

2.durability

3.consistency

4.referential integrity

Posted Date:-2021-07-18 21:14:50


Question:
What is x’ffff’ in decimal?

1.65534

2.66535

3.65536

4.65537

Posted Date:-2021-07-18 21:14:50


Question:
Which mode exists at both global level and session-specific level?

1.sql_mode

2.key_buffer_size

3.server_mode

4.query_mode

Posted Date:-2021-07-18 21:14:50


Question:
Which system variable determines the number of rows from INSERT DELAYED statements that can be queued per table?

1.fast_queue_size

2.general_queue_size

3.slow_queue_size

4.delayed_queue_size

Posted Date:-2021-07-18 21:14:50


Question:
Which system variable enables mysqld to keep more tables open simultaneously?

1.table_cache

2.max_connect

3.delayed_queue_size

4.max_allowed_packet

Posted Date:-2021-07-18 21:14:50


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!