TECHNOLOGY: Inside OCP
The New MasterBy Sushma Jagannath and Narayan Bhandi
Introducing the Oracle Certified Master credential for Oracle Database 11g
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 ExamsObtaining 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:
Oracle Database 11g Certified Master Upgrade ExamThis exam provides a path for Oracle Certified Masters on Oracle9i Database or Oracle Database 10g to upgrade their certification to Oracle Database 11g Certified Master. Candidates need not upgrade the OCP certification; they will instead be granted 11g OCP certification along with 11g master certification when they pass this exam. The exam is based on Oracle Database 11g Release 1.
This one-day practicum tests candidates on four primary areas:
Oracle Database 11g Certified Master ExamCandidates need to be Oracle Certified Professionals on Oracle Database 11g before signing up for this exam. The exam is based on Oracle Database 11g Release 2 and includes the use of Oracle Real Application Clusters (Oracle RAC).
This two-day practicum tests candidates on eight primary areas:
Before You Take the Oracle Database 11g Certified Master ExamHere are some recommendations for candidates who plan to take the Oracle Database 11g Certified Master exam:
Sample TasksThe sample tasks in this section are representative of the types of tasks candidates will be asked to perform on the Oracle Certified Master exams.
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.
Task: Oracle RMAN configuration. Configure Oracle RMAN according to the following specifications, and perform a backup of the ORCL database to recover the database in the event of a failure:
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;
ConclusionThis column covered two Oracle Certified Master exams:
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.
Sushma Jagannath is a certification exam development manager at Oracle. She has been with the company since 2000. Narayan Bhandi is a certification exam development team lead and has been with the company since 2004.
Send us your comments