1. | Using indexes optimizes query performance. |
Answer: (a).True
|
2. | The maximum number of indexes on MyISAM table is __________ |
Answer: (d).more than 1
|
3. | The data rows of a MyISAM table are stored in __________ |
Answer: (a).data file
|
4. | In a single table (with 10 columns) join query the number of values needed to examine per column is __________ |
Answer: (b).10
|
5. | Suppose tbl_1 is a table consisting of 8 rows and tbl_2 is a table consisting of 6 rows, the number of combinations through which the search is performed is __________
|
Answer: (d).48
|
6. | How many of the following shared tablespaces is bound by the OS file size limit?
MyISAM, InnoDB, TRANSACTION |
Answer: (b).1
|
7. | If a column contains 7 values and 6 distinct values, the cardinality is __________ |
Answer: (b).6
|
8. | For a table having 4 columns, the number of columns to which hash function is applied when using hash indexes is __________ |
Answer: (d).4
|
9. | The slow query log can be used to identify queries that may be performing badly. |
Answer: (a).True
|
10. | The slow query log is written as __________ |
Answer: (b).text
|