MYSQL MySQL 5.0 Database Administrator Certified Professional Exam, Part II 認定 1Z0-874 試験問題:

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

A) No, because the table must be sorted.
B) Yes, if the table has any indexes.
C) Yes, because InnoDB stores a row count in the table.
D) No, because InnoDB does not store a row count in the table.

2. Which of the following best describes the purpose of the record buffer (as controlled through the read_buffer_size variable), and how it is set? (Choose two)

A) The record buffer is set per connection.
B) The record buffer is used for operations such as ORDER BY or GROUP BY.
C) The record buffer is global and is only set by restarting the server.
D) The record buffer is used to perform sequential table scans, reducing the number of reads from disk

3. Which of the following steps are used to create database symbolic links on Windows? (Choose four)

A) Use the ln -s command.
B) Move the database directory from the data directory to a new location.
C) Stop the server.
D) Restart the server.
E) Create a file in the data directory with the database name with an extension of .sym that contains the full path to the new location.
F) Update your my.ini with the path to the new location.

4. Can multi-column FULLTEXT indexes be used? If so, when?

A) Yes, they should be used to search multiple columns simultaneously.
B) No, they can not be used.
C) Yes, they can be used to search either one or all of the indexed columns.

5. Which of the following should be done to enable secure logging of events which may be needed for recovery operations and to track down security incidents? (Choose three)

A) Enable the binary log
B) Set permissions on log files so they are only readable by the user owning the mysql process
C) Set the --encrypt-logs option
D) Enable the general log
E) Enable the slow log

質問と回答：