MySQL 5.0 Database Administrator Certified Professional Exam, Part II (1Z0-874) Free Practice Test

Question 1

Connection strings in FEDERATED tables are stored...

A. They are not stored, but must be re-specified at server restart.

B. In a .fed file corresponding to the table.

C. In variables.

D. Within the table definition.

Correct Answer: D

Question 2

Which of the following best describes what the master.info file contains and how it is used? (Choose two)

A. When the slave restarts it looks for which master to use from this file.

B. It contains the values from the CHANGE MASTER statement.

C. It is used by an administrator to determine what slaves connect to the master, and other information about the master server.

D. It contains information about the master server, its slaves and its configuration.

Correct Answer: A,B

Question 3

Consider the following: mysql> EXPLAIN SELECT Name FROM Country WHERE Code = 'CAN' *************************** 1. row *************************** id: 1 select_type: SIMPLE table: Country type: const possible_keys: PRIMARY key: PRIMARY key_len: 3 ref: const rows: 1 Extra: Which of the following best describes the meaning of the value of the type column?

A. Only one row of all its rows need to be read.

B. The table has exactly one row.

C. Several rows may be read from the table.

Correct Answer: A

Question 4

When choosing hardware for your MySQL server, is memory important to MySQL and why? (Choose two)

A. No, because MySQL makes more use of disks and processors than memory.

B. Yes, because more memory allows for larger buffers improving caching and reducing disk usage

C. Yes, because more memory allows for less swapping by the operating system.

D. No, because MySQL makes use of virtual memory on disks.

Correct Answer: B,C

Question 5

How can the SHOW PROCESSLIST command be helpful when optimizing queries?

A. It shows if a query is using an index or not.

B. It shows the percentage of processing power that each query is using on a server.

C. It shows how the server processes a query.

D. If checked periodically, it can reveal a queries that causes other queries to hang.

Correct Answer: D

Question 6

Why should one preferably group multiple statements for InnoDB tables within a transaction whenever it is possible?

A. It minimizes bandwidth usage.

B. It minimizes the amount of flush operations needed.

C. It helps keep log file sizes down.

D. It helps reduce the chance of the transaction failing due to a bad query.

Correct Answer: B

Welcome to TestSimulate

MYSQL MySQL 5.0 Database Administrator Certified Professional Exam, Part II (1Z0-874) Free Practice Test