We're so confident of our products that we provide no hassle product exchange.
MYSQL 1Z0-873 Exam Overview:
| Certification Vendor: | Oracle |
| Exam Name: | MySQL 5.0 Database Administrator Certified Professional Exam, Part I |
| Exam Number: | 1Z0-873 |
| Exam Format: | Multiple Choice Questions (MCQ) |
| Available Languages: | English |
| Exam Duration: | 120 minutes |
| Related Certifications: | MySQL 5.0 Database Administrator Certified Professional Exam, Part II (1Z0-874) |
| Real Exam Qty: | Approximately 70 (varies) |
| Passing Score: | 800 |
| Recommended Training: | Oracle MySQL Training Path |
| Exam Registration: | Oracle Certification Registration |
| Sample Questions: | MYSQL 1Z0-873 Sample Questions |
| Exam Way: | Computer-based exam (typically via Pearson VUE or Oracle testing centers/online proctoring depending on availability) |
| Pre Condition: | Basic understanding of relational databases, SQL, and MySQL administration recommended. |
| Official Syllabus URL: | https://education.oracle.com/ |
MYSQL 1Z0-873 Exam Syllabus Topics:
| Section | Weight | Objectives |
|---|---|---|
| Topic 1: Server Startup, Shutdown and Configuration | 20% | - Log Files and Status Monitoring - Timezone Tables Loading - Upgrading MySQL - Security Configuration - SQL Mode Configuration - Runtime Configuration - Starting and Stopping MySQL Server |
| Topic 2: Locking and Transactions | 10% | - Table Locking - Advisory Locking - Locking Concepts |
| Topic 3: Storage Engines | 20% | - MySQL Storage Engine Overview - MyISAM and InnoDB Engines |
| Topic 4: Character Set Support | 5% | - Character Set Selection and Performance - Data Type Selection for Text Columns |
| Topic 5: Client Programs for DBA Work | 5% | - mysqldump - mysqladmin - mysqlimport - mysql Client |
| Topic 6: Data Maintenance | - Table Maintenance Operations - Information Schema Usage | |
| Topic 7: MySQL Architecture | 10% | - Memory and Disk Usage - Client/Server Overview - SQL Parser and Storage Engine Layers |
| Topic 8: Backup and Recovery | - Backup Methods - Recovery Techniques |
MYSQL MySQL 5.0 Database Administrator Certified Professional Exam, Part I Sample Questions:
1. Which of the following are requirements for InnoDB binary portability?
A) Both machines must use the same operating system.
B) Database and table names must use lowercase format.
C) Both machines must use two's-complement integer arithmetic.
D) Both machines must use IEEE floating-point format or contain no floating-point columns.
2. Which of the following features are supported by MyISAM tables?
A) Assembly of multiple MyISAM tables to a MERGE table
B) Row level locking
C) Fulltext indexes
D) Auto_increment columns
E) Table level locking
F) Foreign key constraints
G) Transactions
3. Besides specifying the column names and data types, which connection parameters may be defined when defining a FEDERATED table?
A) The name and database of the referenced table
B) The user name and password to be used to connect the remote server
C) The compression method to be used
D) The host name of the server where the referenced table is located
E) The operating system of the remote server
4. Which of the following statements is true for mysqldump?
A) It can dump data only on remote servers.
B) It can dump data only on the local server.
C) It can dump data on both local and remote servers.
5. After a server crash, some InnoDB tables need to be repaired. However, when the server is restarted, auto-recover failed. How would you repair the InnoDB tables?
A) Execute the REPAIR TABLE command.
B) Execute the OPTIMIZE TABLE command.
C) Restart the server with the --innodb_force_recovery option.
Solutions:
| Question # 1 Answer: B,C,D | Question # 2 Answer: A,C,D,E | Question # 3 Answer: A,B,D | Question # 4 Answer: C | Question # 5 Answer: C |
By Atalanta
