The Oracle Certified Master credential is designed for Oracle Certified Professionals with advanced training and at least three to four years of professional, enterprise-level experience with Oracle Database. This column introduces two Oracle Database 11g Oracle Certified Master exams, provides details on the target candidates and focus areas of each exam, and describes a few sample tasks that are similar to those in the exams.About the Oracle Certified Master Exams Obtaining the Oracle Certified Master credential requires passing an onsite practical exam—conducted in an Oracle University classroom—that tests candidates on their ability to perform database administration tasks in a live database environment. To become an Oracle Certified Master, a candidate must complete two required advanced DBA courses from Oracle University in addition to passing an Oracle Certified Master exam.
All candidates must complete a certain number of “skillsets” that test their ability to perform complex technical tasks. They are required to complete the tasks with either the command-line interface or Oracle Enterprise Manager, and because the exams are based on the Oracle Enterprise Linux platform, working knowledge of Linux commands is essential. Candidates also need to be prepared to work with the following tools while completing the skillsets:
As shown in the diagram in Figure 1, each Oracle Certified Master candidate participating in the practical exam is provided with two machines: a database server and a management server. Both servers are provided with Oracle Enterprise Linux Release 5.2 and Oracle Database 11g installed. The database server hosts the production database the candidate uses to perform various database administration tasks. The management server hosts Oracle Management Repository, which the candidate uses to perform Oracle Enterprise Manager Grid Control tasks.
Figure 1: Oracle Certified Master examination servers
Depending on a candidate’s current certification, that person needs to take and pass one of the following exams to become an Oracle Certified Master on Oracle Database 11g:
This one-day practicum tests candidates on four primary areas:
This two-day practicum tests candidates on eight primary areas:
Task: Creating a tablespace. Create a tablespace named HRTBS in the ORCL database with the following specifications:
This task tests whether the candidate knows how to create a bigfile tablespace with the given specifications. Also, 16 K is a nonstandard block size, and hence the candidate is expected to do the configuration necessary to create the tablespace.
Task: Creating a partitioned table. Create a partitioned table called PART_EMPLOYEES, using the list-partitioned EMPLOYEES table. The partitions should be stored in the EMPTBS1, EMPTBS2, and EMPTBS3 tablespaces.
The PART_EMPLOYEES table should have the following column specifications:
EMPLOYEE_ID NOT NULL NUMBER(6) EMAIL NOT NULL VARCHAR2(25) HIRE_DATE NOT NULL DATE MANAGER_ID NUMBER(6) DEPARTMENT_ID NOT NULL NUMBER(4)
Next, populate the PART_EMPLOYEES table by executing the populate_parttable.sql script.This task tests whether the candidate knows how to create a partitioned table with the given specifications. The candidate is expected to create a list-partitioned PART_EMPLOYEES table and store each partition in a separate tablespace. (The EMPLOYEES table is configured accordingly before a candidate starts this task.) The candidate will then populate the table, using the script provided.
This task tests whether a candidate knows how to use the Oracle RMAN CONFIGURE command to create persistent settings in the Oracle RMAN environment and then perform a backup. When performing the task, the candidate should use the following settings to enable compression of the backups on disk:
CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSET; CONFIGURE CONTROLFILE AUTOBACKUP ON;
Oracle Database 11g Certified Master Upgrade Exam. This one-day practicum is for candidates who are already Oracle9i Database or Oracle Database 10g certified masters. Candidates are tested on four primary skillsets.
Oracle Database 11g Certified Master Exam. This exam is for candidates who are Oracle Database 11g certified professionals. Candidates are tested on eight primary skillsets over two days.
LEARN more about
Photography byDenys Nevozhai,Unsplash