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


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

1.Falcon

2.FEDERATED

3.InnoDB

4.MyISAM


Question:
How can a view refer to multiple tables?

1.UNION

2.JOIN

3.GROUP

4.SELECT


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


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

1.0

2.1

3.2

4.3


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

1.delete

2.rollback

3.commit

4.update


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

1.FILES

2.STATISTICS

3.SCHEMATA

4.VIEWS


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


Question:
The ALL subquery performs operations on _____________

1.row

2.column

3.table

4.database


Question:
The ALL subquery performs the operation ______

1.row

2.column

3.table

4.database


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

1.Availability

2.Accuracy

3.Adjustability

4.Atomicity


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

1.Compound

2.Concrete

3.Collision

4.Consistency


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

1.VARCHAR

2.BINARY

3.VARBINARY

4.BLOB


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

1.DATE

2.TIME

3.DATETIME

4.TIMESTAMP


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

1.5

2.10

3.20

4.60


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


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

1.ALL

2.NARROW

3.STRICT

4.DISTINCT


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

1.ALL

2.NARROW

3.STRICT

4.DISTINCT


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

1.ALL

2.NARROW

3.STRICT

4.DISTINCT


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

1.1GB

2.2GB

3.4GB

4.8GB


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


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


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


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


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


Question:
The most important configurable resource for MyISAM is _____

1.key cache

2.memory cache

3.time cache

4.speed cache


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

1.0

2.1

3.2

4.3


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


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


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

1.–basedir

2.–datadir

3.–port

4.–socket


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


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

1.GEOMETRY

2.POINT

3.LINESTRING

4.POLYGON


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

1.OBTAIN

2.GET

3.GRANT

4.NEED


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

1.Falcon

2.FEDERATED

3.InnoDB

4.MEMORY


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

1.TRANSACTION

2.InnoDB

3.MyISAM

4.MEMORY


Question:
The stored-routine privileges are contained in _______

1.user

2.db

3.tables_priv

4.procs_priv


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


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

1.INNER JOIN

2.NATURAL JOIN

3.OUTER JOIN

4.CARTESIAN JOIN


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

1.abcd and 1633837924

2.abcd and 4297383361

3.dcba and 1633837924

4.dcba and 4297383361


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

1.WHERE

2.SORT

3.GROUP

4.GROUP BY


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

1.INNER JOIN

2.OUTER

3.NATURAL

4.CARTESIAN


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


Question:
What is the mantissa in -1.58E5?

1.-1.58

2.1.58

3.E

4.5


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

1.key cache

2.memory cache

3.time cache

4.speed cache


Question:
What is the precision of BIGINT?

1.32

2.64

3.128

4.16


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

1.atomicity

2.durability

3.consistency

4.referential integrity


Question:
What is x’ffff’ in decimal?

1.65534

2.66535

3.65536

4.65537


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


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


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


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!