Oracle Certified Professional (OCP)



   
   




About OCP: Oracle Certified Professional


The Oracle Certified Professional (OCP) exam includes three steps. All the three steps MUST be completed to become eligible for the OCP certification.


  1. Complete one of the approved instructor-led online or in-classes

  2. Oracle Database 10g: Administration II (1zo-043)

  3. Complete the course submission form




BACK TO TOP

Levels

Professional Certification Path
STEP 1 - PRIOR CERTIFICATION
Oracle PL/SQL Developer Certified Associate
V
STEP 2 – PASS THIS EXAM
1Z0-141 Oracle Forms: Build Internet Applications
Oracle Forms Developer Certified Professional
 
Professional Certification Path
STEP 1 - PRIOR CERTIFICATION
Oracle Certified Associate
V
STEP 2 - COMPLETE TRAINING
Complete one of the approved advanced courses
V
STEP 3 - PASS THIS EXAM
Oracle Database 10g: Administration II 1Z0-043
V
STEP 4 - COMPLETE THIS FORM
Complete the Course Submission Form
Oracle Database 10g Administrator Certified Professional
Next Steps
Oracle Certified Master

BACK TO TOP

Syllabus

OCP
Oracle Database 10g: Administration II
(1z0-043)

Using Globalization Support Objectives
[  ] Customize language-dependent behavior for the database and individual sessions
[  ] Specify different linguistic sorts for queries
[  ] Use datatime datatypes
[  ] Query data using case insensitive and accent insensitive searches
[  ] Obtain Globalization support configuration information
Configuring Recovery Manager
[  ] Configure database parameters that affect RMAN operations
[  ] Change RMAN default settings with CONFIGURE
[  ] Manage RMAN's persistent settings
[  ] Start RMAN utility and allocate channels
Recovering from User Errors
[  ] Recover a dropped table using Flashback technology
[  ] Perform Flashback table operation
[  ] Manage the recycle bin
[  ] Recover from user errors using Flashback versions query
[  ] Perform transaction level recovery using Flashback Transaction query
Dealing with Database Corruption
[  ] Define block corruption and list its causes and symptoms
[  ] Detect database corruptions using the following utilities: ANALYZE
DBVERIFY
[  ] Detect database corruptions using the dbms_repair package
[  ] Implement the DB_BLOCK_CHECKING parameter to detect corruptions
[  ] Repair corruptions using RMAN
Automatic Database Management
[  ] Use the Database Advisors to gather information about your database
[  ] Use the SQL Tuning Advisor to improve database performance
[  ] Use automatic undo retention tuning
Using Recovery Manager
[  ] Use the RMAN BACKUP command to create backup sets and image copies
[  ] Enable block change tracking
[  ] Manage the backups and image copies taken with RMAN with the LIST and REPORT commands
Recovering from Non-Critical Losses
[  ] Recover temporary tablespaces
[  ] Recover a redo log group member
[  ] Recover index tablespaces
[  ] Recover read-only tablespaces
[  ] Recreate the password file
Monitoring and Managing Storage
[  ] Tune redo writing and archiving operations
[  ] Issue statements that can be suspended upon encountering space condition errors
[  ] Reduce space-related error conditions by proactively managing tablespace usage
[  ] Reclaim wasted space from tables and indexes using the segment shrink functionality
[  ] Estimate the size of new table and indexes
[  ] Use different storage options to improve the performance of queries
[  ] Rebuild indexes online
Automatic Storage Management
[  ] Set up initialization parameter files for ASM and database instances
[  ] Execute SQL commands with ASM file names
[  ] Start up and shut down ASM instances
[  ] Administer ASM disk groups
[  ] Use RMAN to migrate your database to ASM
Monitoring and Managing Memory
[  ] Implement Automatic Shared Memory Management
[  ] Manually configure SGA parameters for various memory components in the SGA
[  ] Use Automatic PGA Memory Management

Database Recovery
[  ] Recover the control file
[  ] Explain reasons for incomplete recovery
[  ] Perform incomplete recovery using EM
[  ] Perform incomplete recovery using RMAN
[  ] Perform incomplete recovery using SQL
[  ] Perform database recovery following a RESETLOGS operation
Flashback Database  
[  ] Determine which flashback technology to use for each recovery situation
[  ] Configure and use Flashback Database
[  ] Monitor the Flashback Database
[  ] Use the Enterprise Manager Recovery Wizard to flashback database
[  ] Manage (or maintain) the Flash Recovery Area
Managing Resources
[  ] Configure the Resource Manager
[  ] Assign users to Resource Manager groups
[  ] Create resource plans within groups
[  ] Specify directives for allocating resources to consumer groups
Automating Tasks with the Scheduler
[  ] Simplify management tasks by using the Scheduler
[  ] Create a job, program, schedule, and window
[  ] Reuse Scheduler components for similar tasks
[  ] View information about job executions and job instances
 

BACK TO TOP

Question Pattern

OCP
Oracle Database 10g: Administration II
(1z0-043)

Exam code Name No. of questions Duration Pass mark
1z0-043 Oracle Database 10g:
Administration II
88 Questions 90 minutes Passing at 70%

BACK TO TOP

© 2012 - 2013 Dr. M.G.R. University
Designed by : Salim & Rahul