1. | The recovery of data changes made since a given point in time is called _____________ |
Answer: (b).incremental
|
2. | What performs a key distribution analysis and stores the distribution for the named table or tables? |
Answer: (a).ANALYZE TABLE
|
3. | Which of the following columns is not returned by ‘OPTIMIZE TABLE’? |
Answer: (d).Msg_txt
|
4. | REPAIR TABLE does not work for _____________ |
Answer: (c).InnoDB
|
5. | The binary protocol is easy to use. |
Answer: (b).False
|
6. | What is a synonym for CHARACTER SET? |
Answer: (c).CHARSET
|
7. | The line which is written at the top of the script to write a Perl script using CGI.pm is ______________ |
Answer: (c).use CGI
|
8. | To perform consistency checks on a MyISAM table the statement is _____________ |
Answer: (a).CHECK TABLE
|
9. | The statement that performs key distribution analysis and stores the distribution for the named tables is _____________ |
Answer: (b).ANALYZE TABLE
|
10. | The column not returned by ‘OPTIMIZE TABLE’ is _____________ |
Answer: (b).Msg_txt
|