1. Using indexes optimizes query performance. a. True b. False c. May be True or False d. Can't say

 2. The maximum number of indexes on MyISAM table is __________ a. 0 b. 1 c. 2 d. more than 1

 3. The data rows of a MyISAM table are stored in __________ a. data file b. index file c. log file d. error file

 4. In a single table (with 10 columns) join query the number of values needed to examine per column is __________ a. 1 b. 10 c. 0 d. 2

 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 __________ SELECT tbl_1.i1, tbl_2.i2 FROM tbl_1 INNER JOIN tbl_2 WHERE tbl_1.i1 = tbl_2.i2; a. 14 b. 2 c. 1 d. 48

 6. How many of the following shared tablespaces is bound by the OS file size limit? MyISAM, InnoDB, TRANSACTION a. 0 b. 1 c. 2 d. 3

 7. If a column contains 7 values and 6 distinct values, the cardinality is __________ a. 7 b. 6 c. 13 d. 1