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 |
| Real Exam Qty: | Approximately 70 (varies) |
| Exam Duration: | 120 minutes |
| Exam Format: | Multiple Choice Questions (MCQ) |
| Passing Score: | 800 |
| Available Languages: | English |
| Related Certifications: | MySQL 5.0 Database Administrator Certified Professional Exam, Part II (1Z0-874) |
| 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 |
|---|---|---|
| Server Startup, Shutdown and Configuration | 20% | - Upgrading MySQL - Timezone Tables Loading - Log Files and Status Monitoring - SQL Mode Configuration - Starting and Stopping MySQL Server - Security Configuration - Runtime Configuration |
| Storage Engines | 20% | - MySQL Storage Engine Overview - MyISAM and InnoDB Engines |
| MySQL Architecture | 10% | - SQL Parser and Storage Engine Layers - Client/Server Overview - Memory and Disk Usage |
| Backup and Recovery | - Recovery Techniques - Backup Methods | |
| Locking and Transactions | 10% | - Advisory Locking - Table Locking - Locking Concepts |
| Client Programs for DBA Work | 5% | - mysqlimport - mysqladmin - mysql Client - mysqldump |
| Data Maintenance | - Information Schema Usage - Table Maintenance Operations | |
| Character Set Support | 5% | - Data Type Selection for Text Columns - Character Set Selection and Performance |
MYSQL MySQL 5.0 Database Administrator Certified Professional Exam, Part I Sample Questions:
1. Which of the following is true of the mysqldump client program?
A) It can only backup tables from InnoD
B) It can only backup tables from MyISAM.
C) It can backup tables from any of the available storage engines.
D) It can only backup tables from MyISAM and InnoDB.
2. What three data components are needed for data recovery?
A) configuration files.
B) The general log.
C) The slow log.
D) The backup log.
E) The binary log.
F) The data backup.
3. Consider the three binary log files bin.00010, bin.00011 and bin.00012 which you want to restore data from. How should you process these files when using mysqlbinlog to satisfy inter-file dependencies?
A) shell> mysqlbinlog bin.00010 bin.00011 bin.00012 | mysql
B) shell> mysqlbinlog bin.00010 | mysqlshell> mysqlbinlog bin.00011 | mysqlshell> mysqlbinlog bin.00012 |mysql
C) You can use both of the above statements, i.e. process the files either in a group or separately. All inter-file dependencies will be taken care of with both methods.
4. Which of the following steps describe how to do a proper binary backup of MyISAM tables?
A) Always stop the server prior to the backup
B) Make a copy of the binary log and tablespace files
C) Stop the server or lock the tables prior to the backup
D) Make a copy of the .frm, .MYD and the .MYI files.
E) Stop the server or lock the databases prior to the backup
5. Suppose your are adding rows to a MyISAM table and the server runs out of disk space. What will happen?
A) The server will crash.
B) The server suspends that INSERT operation until space becomes available.
C) An error message will be returned to the client.
D) The server suspends operations on all MyISAM tables until space becomes available.
Solutions:
| Question # 1 Answer: C | Question # 2 Answer: A,E,F | Question # 3 Answer: A | Question # 4 Answer: C,D | Question # 5 Answer: B |
By Deborah
