MySQL 5.0 Database Administrator Certified Professional Exam, Part II: 1Z0-874

Doing SELECT COUNT(*) queries in InnoDB is efficient...

A. Yes, because InnoDB stores a row count in the table.

B. No, because InnoDB does not store a row count in the table.

C. Yes, if the table has any indexes.

D. No, because the table must be sorted.

Which of the following disk characteristics are most important to a database server and why?

A. Disk size, because a database needs a lot of storage space.

B. Transfer rate, because the database needs to be able to transfer the data off the disks at a very high rate.

C. Disk seek time, because it is more important for the heads of the disk to move quickly from track to track.

Which of the following best describes what may limit the number of simultaneous connections to the server? What are possible ways to increase it?

A. It is limited by the maximum size of the table cache.

B. The --key_cache option may be used to increase the limit.

C. The maximum number of threads per-process of the operating system.

D. The operating system may be able to be reconfigured to increase this limit.