Oracle 1z0-874 : MySQL 5 Database Administrator Certified Professional (Part II) Exam
The Oracle 1z0-874 MySQL 5 Database Administrator CP exam is comprised of 65 questions in a 90-minute timeframe. It is the second requirement for the Oracle Certified Professional, MySQL 5 Database Administrator certification, which recognizes that server-related issues, such as installation, keeping the server running problem-free, using the storage simulator, and analyzing the trouble spots of other users' queries, have been comprehended. A passing score of 66% is required.
Exam topics include Stored Routines, User Management, Securing the Server, Upgrade-Related Security Issues, Optimizing Queries, Schemas, and the Server, Interpreting Error Messages, Optimizing the Environment, and Scaling. A training course is available as a preparation source. The Oracle 1z0-874 exam is only available in English.
Participants should know how to use stored routines for security purposes and to enhance performance. User account management and client access control should be understood. Knowledge on security issues and server security is beneficial. Participants should be able to do such things as upgrade the Privilege Tables, identify candidates for query analysis, distinguish between optimizations, understand aspects of server and environment optimization, and interpret error messages.