on Oracle Database 11 g Release 2 and
includes the use of Oracle Real Application
Clusters (Oracle RAC).
This two-day practicum tests candidates
on eight primary areas:
Creating database and network •
configurations
Managing database availability •
Database warehouse management •
Data management •
Performance management •
Oracle Enterprise Manager Grid Control •
Oracle Data Guard •
Grid infrastructure, Oracle Automatic •
Storage Management, and Oracle RAC
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.
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:
the following settings to enable compres-
sion of the backups on disk:
CONFIGURE DEVICE TYPE DISK BACKUP TYPE
TO COMPRESSED BACKUPSET;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
Before;You;Take;The;oracle;Da TaBase
11 g;cer TifieD;Mas Ter;exaM
Here are some recommendations for candi-
dates who plan to take the Oracle Database
11 g Certified Master exam:
Gain considerable hands-on expertise with •
all the exam objectives.
Get comfortable with the Linux command •
language—you will need to perform
certain operating-system-level tasks such
as executing a script and moving/copying
a file/directory.
Be prepared to use all the tools listed in •
this column.
Practice completing tasks within a time •
limit. Working out each of the skillsets
within a stipulated time is one of the key
factors in achieving this certification.
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.
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:
Enable compression for the backups •
on disk
Configure automatic backup of the control •
file and server parameter file
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
coNclusioN
This column covered two Oracle Certified
Master exams:
oracle;Database;11 g;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;11 g;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.
saMple;Tasks
The 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:
Tablespace name: HRTBS •
Block size: 16 K •
File size: expected to grow to 3 TB •
Initial extent size: 1 MB •
Next extent size: 1 MB •
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
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.
NEXT STEPS
LEARN more about the Oracle Certification
Program, and download a free exam guide
oracle.com/education/certification
GE T more Oracle Certified Master
information
bit.ly/bt7sft
REVIE W names and profiles of Oracle
Certified Masters
oracle.com/technology/ocm
READ Inside OCP columns
bit.ly/ahxmnp
NOVEMBER/DECEMBER 2010
ORACLE.COM/ORACLEMAGAZINE
