We're so confident of our products that we provide no hassle product exchange.
MYSQL 1Z0-873 Exam Overview:
| Certification Vendor: | Oracle (MySQL) |
| Exam Name: | MySQL 5.0 Database Administrator Certified Professional Exam, Part I |
| Exam Number: | 1Z0-873 |
| Available Languages: | English, Japanese |
| Passing Score: | 66% |
| Real Exam Qty: | 71 |
| Related Certifications: | 1Z0-874 MySQL 5.0 Database Administrator Certified Professional Exam, Part II |
| Certificate Validity Period: | Retired, no active validity; superseded by newer MySQL certifications |
| Exam Duration: | 90 minutes |
| Exam Format: | Multiple Choice, Single/Multiple Answer |
| Exam Price: | USD $195–$245 (varies by region) |
| Recommended Training: | MySQL 5.0 Database Administrator Study Guide Oracle Official MySQL Training |
| Exam Registration: | Oracle Certification Portal Pearson VUE Registration |
| Sample Questions: | MYSQL 1Z0-873 Sample Questions |
| Exam Way: | Proctored onsite at Pearson VUE test centers; no online remote delivery |
| Pre Condition: | No formal prerequisites; recommended practical experience with MySQL 5.0 |
| Official Syllabus URL: | https://education.oracle.com/certification |
MYSQL 1Z0-873 Exam Syllabus Topics:
| Section | Weight | Objectives |
|---|---|---|
| Topic 1: Starting, Stopping, and Configuring MySQL | 20% | - Startup methods and options - Configuration files and variables - Runtime configuration adjustments - Shutdown procedures |
| Topic 2: Data and Table Maintenance | 10% | - Checking and repairing tables - Managing fragmentation - Optimizing tables and indexes - Analyzing table statistics |
| Topic 3: MySQL Architecture | 10% | - Client-server communication model - Storage engine separation - Disk and memory usage structure - SQL parser and execution layers |
| Topic 4: Storage Engines | 20% | - InnoDB engine and transactions - MyISAM engine features - Memory, CSV, Archive, and Federated engines - Choosing appropriate storage engines |
| Topic 5: The INFORMATION_SCHEMA Database | 5% | - Accessing metadata - Querying schema objects - Monitoring server state |
| Topic 6: Locking Mechanisms | 10% | - Transaction isolation levels - Row-level locking - Table-level locking - Lock contention and deadlocks |
| Topic 7: Character Set Support | 5% | - Conversion and compatibility issues - Server, database, table, and column level settings - Character sets and collations |
| Topic 8: Data Backup and Recovery Methods | 15% | - Binary log usage for point-in-time recovery - Restoring from backups - Logical backups with mysqldump - Binary backups and file system copies |
| Topic 9: Client Programs for DBA Work | 5% | - mysqladmin utility - mysql command-line client - mysqlcheck and other admin tools |
MYSQL MySQL 5.0 Database Administrator Certified Professional Exam, Part I Sample Questions:
1. which of the following best describes why table locking is often not desirable compared to page or row locking?
A) Table locks create concurrency issues.
B) Table locks can cause data corruption issues if more than one client tries to make changes while locked.
C) Table locks can have deadlocks.
D) Table locks prevent other clients from making any changes to the table until released.
2. When specifying options, which of the following are valid advantages of using options files over parameters on a command line?
A) Options will not need to be specified every time the server starts.
B) All options can be consolidated to one file and a single point of reference.
C) Certain options can be specified only in options files but not on the command line
3. mysqldump can be instructed to include commands to drop and recreate tables before trying to create or load data.
A) True
B) False
4. Which of the following statements are true regarding the data directory on a Windows binary installation?
A) It comes pre-initialized.
B) You can choose to pre-initialize it or initialize it manually during the installation.
C) A script needs to be run to initialize it after installation.
5. Suppose you install a server with a service name of "MySQL5" rather than the default. What sections in the option files will the server use for configuration?
A) [MySQL5]
B) [service MySQL5]
C) [mysqld]
D) [mysqld MySQL5]
E) [service]
Solutions:
| Question # 1 Answer: A | Question # 2 Answer: A,B | Question # 3 Answer: A | Question # 4 Answer: A | Question # 5 Answer: A,C |
By Eileen
