SQL MCQ Quiz Hub

1. In which table of INFORMATION_SCHEMA is the information about table index characteristics stored?
FILES
STATISTICS
SCHEMATA
VIEWS

2. What is the join where all possible row combinations are produced?
INNER JOIN
OUTER
NATURAL
CARTESIAN

3. What is the clause that filters JOIN results called?
WHERE
SORT
GROUP
GROUP BY

4. What are CROSS JOIN and JOIN are similar to?
INNER JOIN
NATURAL JOIN
OUTER JOIN
CARTESIAN JOIN

5. The grant table that stores users who can connect to the server and their global privileges are ______
user
db
tables_priv
procs_priv

6. The stored-routine privileges are contained in _______
user
db
tables_priv
procs_priv

7. The statement used to obtain access privileges to an account is _______
OBTAIN
GET
GRANT
NEED

8. The operators used when a subquery returns multiple rows to be evaluated in comparison to the outer query are _______
IN and NOT IN
EXISTS and NOT EXISTS
OUTER JOIN and INNER JOIN
LEFT JOIN and RIGHT JOIN

9. The ALL subquery performs the operation ______
row
column
table
database

10. The keyword used with UNION that does not retain duplicate rows is _______
ALL
NARROW
STRICT
DISTINCT

11. The keyword used with UNION that retains duplicate rows is ________
ALL
NARROW
STRICT
DISTINCT

12. The log that contains a record of server startups and shutdowns and the messages about exceptional conditions is ______
error log
general query
slow query log
binary log

13. The log that identifies statements that may be in need of being rewritten for better performance is ________
error log
general query
slow query log
binary log

14. The default value in seconds in the system variable ‘long_query_time’ is ______
5
10
20
60

15. The logging option to enable binary log index file is _______
_log-bin-index
_bin-log-index
_index-log-bin
_index-bin-log

16. The operators that are used when a subquery returns multiple rows to be evaluated in comparison to the outer query are ____________
IN and NOT IN
EXISTS and NOT EXISTS
OUTER JOIN and INNER JOIN
LEFT JOIN and RIGHT JOIN

17. The ALL subquery performs operations on _____________
row
column
table
database

18. What is the kind of delete when deletion of an employee from the table also deletes that employee from another table?
transparent
concrete
elaborate
cascaded

19. The storage engine in MySQL that provides foreign key support is ___________
TRANSACTION
InnoDB
MyISAM
MEMORY

20. What is the property of InnoDB that enforces foreign key relationships stay intact?
atomicity
durability
consistency
referential integrity

21. Which mode exists at both global level and session-specific level?
sql_mode
key_buffer_size
server_mode
query_mode

22. Which system variable determines the number of rows from INSERT DELAYED statements that can be queued per table?
fast_queue_size
general_queue_size
slow_queue_size
delayed_queue_size

23. The largest value to which the variable ‘max_allowed_packet’ can be set is _______
1GB
2GB
4GB
8GB

24. Increasing the value of which system variable enables mysqld to keep more tables open simultaneously?
table_cache
max_connect
delayed_queue_size
max_allowed_packet

25. The keyword used with UNION that retains duplicate rows is ___________
ALL
NARROW
STRICT
DISTINCT

26. The search mode that uses natural language search as a subroutine is ________
Natural language
Boolean mode
Query expansion
Cross mode

27. For what can the FULLTEXT indexes be created for?
MyISAM
InnoDB
MEMORY
TRANSITION

28. For which of these storage engines are configuration options always built?
Falcon
FEDERATED
InnoDB
MyISAM

29. The storage engine for which the runtime options are always enabled is ______
Falcon
FEDERATED
InnoDB
MEMORY

30. The most important configurable resource for MyISAM is _____
key cache
memory cache
time cache
speed cache

31. Which system variable enables mysqld to keep more tables open simultaneously?
table_cache
max_connect
delayed_queue_size
max_allowed_packet

32. How can a view refer to multiple tables?
UNION
JOIN
GROUP
SELECT

33. What is the mantissa in -1.58E5?
-1.58
1.58
E
5

34. What is the precision of BIGINT?
32
64
128
16

35. How many digits is the DECIMAL used for expressions containing only exact values with fractional part?
32
64
65
16

36. The LOCAL capability for client library is enabled by _______
_enabled-local-file
_enable-local-infile
_enable-global-file
_enable-local-file

37. What is the most important configurable resource for MyISAM?
key cache
memory cache
time cache
speed cache

38. How many options can be used to control LOCAL capability at runtime?
0
1
2
3

39. The mode used to turn off the special meaning of backslash and treat it as an ordinary character is ______
NO_ESCAPES_SLASH
NO_ESCAPES_BACKSLASH
NO_BACKSLASH_ESCAPES
NO_BACKSLASH_ESCAPE

40. What is x’ffff’ in decimal?
65534
66535
65536
65537

41. What are X’61626364′ and X’61626364′?
abcd and 1633837924
abcd and 4297383361
dcba and 1633837924
dcba and 4297383361

42. The variable which represents the default time zone of the MySQL server is _______
time_zone
system_time_zone
date_and_time
system_time

43. The number of options that can be used to control LOCAL capability at runtime is _____
0
1
2
3

44. If an error occurs during the transaction the troubleshoot is ______
delete
rollback
commit
update

45. The ‘A’ in the ACID property of transactions is _____
Availability
Accuracy
Adjustability
Atomicity

46. The ‘C’ in the ACID property of transactions is ____
Compound
Concrete
Collision
Consistency

47. The datatype that means a variable length non binary string is _____
VARCHAR
BINARY
VARBINARY
BLOB

48. The date and time datatype that stores time value in ‘hh:mm:ss’ format is ______
DATE
TIME
DATETIME
TIMESTAMP

49. The spatial datatype used to store a curve is _______
GEOMETRY
POINT
LINESTRING
POLYGON

50. The option that supplies the pathname to root directory of MySQL installation is _______
–basedir
–datadir
–port
–socket