MYSQL 1Z0-874 Actual Free Exam Questions & Community Discussion

Exam Code/Number: 1Z0-874
Exam Name/Title: MySQL 5.0 Database Administrator Certified Professional Exam, Part II
Certification Provider: MYSQL
Corresponding Certification: MYSQL-Certifications

Exam Questions: 140
Updated On: Aug 21, 2026

Question #1

What benefits do you get after compressing a MyISAM table? (Choose two)

A. Retrieving rows usually becomes faster.

B. The files on disk consume less space.

C. The index information will be kept fully in memory, which results in faster performance when using WHERE clauses.

D. Using COUNT(*) is faster since the number of rows is constant.

Discussion 0

Correct Answer: A,B Vote an answer

Question #2

Consider the following: mysql> EXPLAIN SELECT Name FROM Country WHERE Population BETWEEN 1 AND 10000 *************************** 1. row *************************** id: 1 select_type: SIMPLE table: Country type: range possible_keys: i_pop key: i_pop key_len: 4 ref: NULL rows: 10 Extra: Using where
What is the meaning of the range value of the type column?

A. There is a range of indexes that can be used.

B. The optimizer has determined that only data from the very beginning or the very end of the table is needed

C. The type of index uses the range algorithm.

D. The index is used to select rows that fall between a range of index values.

Discussion 0

Correct Answer: D Vote an answer

Question #3

Granting access to the mysql database...

A. Should only be done on administrator accounts.

B. Should never be done for any users.

C. Should be done for anyone needing to create views

D. Should always be done for all users.

Discussion 0

Correct Answer: A Vote an answer

Question #4

Why should log files be secured against reading by non-authorized users? (Choose two)

A. Usernames and passwords could be revealed.

B. Data values may be read

C. Unauthorized users may alter the log contents.

D. The server may be prevented from writing to the log file

Discussion 0

Correct Answer: A,B Vote an answer

Question #5

Which of the following are methods to improve performance? (Choose two)

A. Moving the MySQL utilities such as mysqladmin to different disks pointed to by a symbolic link.

B. Spreading single tables to different disks pointed to by a symbolic link.

C. Spreading whole databases to different disks pointed to by a symbolic link.

D. Moving less needed parts of the MySQL install such as the documentation or the test files to different disks pointed to by a symbolic link.

Discussion 0

Correct Answer: B,C Vote an answer

Question #6

How can stored routines be used to check for constraints or legality

A. They can make use of the VALIDATE DEFINER setting.

B. They cannot be used to check for constraints or legality of data.

C. They can check and only perform an action if the incoming values match a specified value.

Discussion 0

Correct Answer: C Vote an answer

Question #7

Is it possible to tell the MySQL server to throw an error on illegal dates rather than converting it to zero-date or legal dates?

A. No, all illegal date are converted regardless of any setting.

B. Yes, by updating a system variable.

C. No, it has to be done programmatically.

D. Yes, there is a SQL mode that exists for that.

Discussion 0

Correct Answer: D Vote an answer

Question #8

In regards to security, which of the following statements are true? (Choose two)

A. Mysqld should be run as root or administrator.

B. The user owning the server process should own all files and directories to which the server may write.

C. Mysqld should not be run as root or administrator.

D. The root or admininistrator users should own all files related to the server process

Discussion 0

Correct Answer: B,C Vote an answer

Download Free MYSQL 1Z0-874 Demo

Simply submit your e-mail address below to get started with our free demo of your MYSQL 1Z0-874 exam.