We're so confident of our products that we provide no hassle product exchange.
MYSQL 1Z0-874 Exam Overview:
| Certification Vendor: | Oracle (Sun Microsystems legacy MySQL certification) |
| Exam Name: | MySQL 5.0 Database Administrator Certified Professional Exam Part II |
| Exam Number: | 1Z0-874 |
| Certificate Validity Period: | Retired / no longer offered |
| Available Languages: | English |
| Exam Price: | Varies by region (historically ~USD 200–300 equivalent) |
| Related Certifications: | MySQL 5.0 Database Administrator Certified Professional Exam Part I (1Z0-873) MySQL Database Administrator Certified Professional (legacy track) |
| Exam Format: | Multiple choice, Scenario-based questions |
| Real Exam Qty: | Unknown (historical range typically ~50–70) |
| Exam Duration: | 120 minutes |
| Passing Score: | Unknown (historical exam, not publicly standardized across all regions) |
| Recommended Training: | Oracle MySQL Documentation Oracle University Training |
| Exam Registration: | Pearson VUE Oracle Exams Oracle Certification Registration |
| Sample Questions: | MYSQL 1Z0-874 Sample Questions |
| Exam Way: | Historically delivered via Pearson VUE proctored testing centers |
| Pre Condition: | Recommended completion of Part I (1Z0-873) or equivalent professional MySQL DBA experience |
| Official Syllabus URL: | https://education.oracle.com/ |
MYSQL 1Z0-874 Exam Syllabus Topics:
| Section | Objectives |
|---|---|
| User Management and Security | |
| Installation, Configuration, and Server Setup | |
| Storage Engines and Table Management | |
| MySQL Architecture and Core Components | |
| Monitoring, Maintenance, and Troubleshooting | |
| Replication and High Availability | |
| Backup, Restore, and Recovery | |
| Performance Tuning and Optimization |
MYSQL MySQL 5.0 Database Administrator Certified Professional Exam, Part II Sample Questions:
1. Consider the following two partial outputs of the SHOW VARIABLES command on a master and slave server: Master:
+--------------------------+---------------------------+
| Variable_name | Value |
+--------------------------+---------------------------+
| connect_timeout | 5 |
| log_bin | ON |
| max_connections
| 100 |
| shared_memory_base_name | MYSQL |
| server_id | 2 |
| tmp_table_size | 5242880 |
| version | 5.0.13-rc-nt |
Slave:
+--------------------------+---------------------------+
| Variable_name | Value |
---------------------------+---------------------------+
| connect_timeout | 5 |
| log_bin | ON |
| max_connections | 10 |
| shared_memory_base_name | MYSQL |
| server_id | 2 |
| tmp_table_size | 4266336 |
| version | 5.0.16-rc-nt |
There is apparently a problem with the slave replicating from the master. Which of the following best describes the most likely problem?
A) The version of the slave is newer than the version of the master.
B) The connect_timeout variable needs to be increased.
C) The max_connections variable needs to be increased.
D) The server_id is not unique.
2. When working with stored routines, which of the following are true in regards to the effect on the amount of data exchanged between client and server?
A) They have no effect on the amount of data exchanged.
B) They can help reduce the amount of data exchanged.
C) They may increase the amount of data exchanged.
3. Consider the following:
+----+-----------------+--------------+
| id | PartName | Location |
+----+-----------------+--------------+
| 1 | 40GB Hard Drive | Jacksonville |
| 2 | 1GB DDR | Atlanta |
| 3 | Keyboard | San Jose |
| 4 | Monitor | Harrisburg |
| 5 | USB Drive | Miami |
| 6 | DVD/R | Jacksonville |
+----+-----------------+--------------+
Which of the following best describes why this table should be split into a part and location table?
A) Because it has redundant location values.
B) This table should not be split as it is already in third normal form.
C) Because it has multiple repeating groups in each row.
4. Which of the following best describes the purpose of the max_allowed_packet parmeter, and when it is set? (Choose two)
A) The max_allowed_packet parameter is used to control the buffer that is used for communication between the server and the client.
B) The max_allowed_packet parameter is used to control the size of the dataset that is sent to the client.
C) The max_allowed_packet parameter is global and is only set by shutting down the server.
D) The max_allowed_packet parameter is set per-connection.
5. Which of the following statements best describe the indexes supported by the MEMORY storage engine, and their general characteristics?
A) MEMORY tables only support HASH indexes which provide fast lookups that use a unique index.
B) MEMORY tables only support BTREE which provide better performance with non-unique index values and other comparison operators.
C) MEMORY tables support HASH indexes which provide better performance with non-unique index values and other comparison operators, and BTREE indexes which provide fast lookups that use a unique index.
D) MEMORY tables support HASH indexes which provide fast lookups that use a unique index, and BTREE indexes which provide better performance with non-unique index values and other comparison operators.
Solutions:
| Question # 1 Answer: D | Question # 2 Answer: B | Question # 3 Answer: A | Question # 4 Answer: A,D | Question # 5 Answer: D |
By Beulah
