|
|
There are five certification tracks for OCP, these being:
- Oracle 9i DBA
Certified Oracle9i DBAs have a complete understanding and knowledge base
to keep the database environment running all the time. They are able to
install, maintain, troubleshoot, and fine-tune the Oracle9i database with
all the newest features the Oracle9i database offers.
- Oracle 8i DBA
Certified Oracle8i DBAs have comprehensive administration skills from
installing, maintaining, troubleshooting and fine-tuning an Oracle8i
database.
- iDBO
Certified Internet Database Operators provide routine administrative
tasks on the Oracle database and help support DBAs in the management of
an Oracle database and web-based applications using Oracle Enterprise
Manager.
- Oracle Java Developer, Oracle JDeveloper
A Java Developer designs, creates and maintains Internet applications
and web pages. Java is the essential skill to build dynamic web pages
and Internet applications and is the underlying platform for the
Internet Age.
- Internet Application Developer, Oracle Forms Developer 6/6i
A Forms Developer designs, creates and maintains Internet applications
using Oracle Forms and exploits the Oracle9iAS Forms Services framework
for deploying these complete business applications to the Internet.
This document tries to give a comprehensive overview on what the requirements are for becoming an OCP of the first track (DBA 9i)j
First, the introduction to Oracle 9i SQL (#1Z0-007) or introduction to Oracle: SQL and PL/SQL (#1Z0-001) must be passed.
Then, the Oracle 9i Database: Fundamentals I (#1Z0-031) must be passed as well:
- Oracle Architectural Components
- Describe the Oracle architecture and its main components
- Describe the structures involved in connecting a user to an Oracle instance
- Getting Started With the Oracle Server
- Identify common database administrative tools available to a DBA
- Identify the features of the Oracle Universal Installer
- Explain the benefits of Optimal Flexible Architecture
- Set up password file authentication
- List the main components of the Oracle Enterprise Manager and their uses
- Managing an Oracle Instance
- Create and manage initialization parameter files
- Configure OMF
- Start up and shut down an instance
- Monitor the use of diagnostic files
- Creating a Database
- Describe the prerequisites necessary for database creation
- Create a database using Oracle Database Configuration Assistant
- Create a database manually
- Data Dictionary Content and Usage
- Identify key data dictionary components
- Identify the contents and uses of the data dictionary
- Query the data dictionary
- Maintaining the Control File
- Explain the uses of the control file
- Describe the contents of the control file
- Multiplex and manage the control file
- Manage the control file with Oracle Managed Files
- Obtain control file information
- Maintaining Redo Log Files
- Explain the purpose of online redo log files
- Describe the structure of online redo log files
- Control log switches and checkpoints
- Multiplex and maintain online redo log files
- Manage online redo log files with OMF
- Managing Tablespaces and Data files
- Describe the logical structure of tablespaces within the database
- Create tablespaces
- Change the size of the tablespace
- Allocate space for temporary segments
- Change the status of tablespaces
- Change the storage settings of tablespaces
- Implement Oracle Managed Files
- Storage Structure and Relationships
- Describe the logical structure of segments within the database
- Describe the segment types and their uses
- List the keywords that control block space usage
- Obtain information about storage structures from the data dictionary
- Managing Undo Data
- Managing Tables
- Identify the various methods of storing data
- Describe Oracle data types
- Distinguish between an extended versus a restricted ROWID
- Describe the structure of a row
- Create regular and temporary tables
- Manage storage structures within a table
- Reorganize, truncate, drop a table
- Drop a column within a table
- Managing Indexes
- Describe the different types of indexes and their uses
- Create various types of indexes
- Reorganize indexes
- Drop indexes
- Get index information from the data dictionary
- Monitor the usage of an index
- Maintaining Data Integrity
- Implement data integrity constraints
- Maintain integrity constraints
- Obtain constraint information from the data dictionary
- Managing Password Security and Resources
- Manage passwords using profiles
- Administer profiles
- Control use of resources using profiles
- Obtain information about profiles, password management and resources
- Managing Users
- Create new database users
- Alter and drop existing database users
- Monitor information about existing users
- Managing Privileges
- Identify system and object privileges
- Grant and revoke privileges
- Identify auditing capabilities
- Managing Roles
- Create and modify roles
- Control availability of roles
- Remove roles
- Use predefined roles
- Display role information from the data dictionary
- Using Globalization Support
- Choose database character set and national character set for a database
- Specify the language- dependent behavior using initialization parameters,
environment variables and the ALTER SESSION command
- Use the different types of National Language Support (NLS) parameters
- Explain the influence on language-dependent application behavior
- Obtain information about Globalization Support usage
Oracle9i Database Administrator Certified Professional (2 exams)
The Oracle Certified Professional credential is the next step in a
rewarding career working with Oracle technologies. After achieving
your Oracle Associate credential, you will need to continue your
Oracle training and gain on-the-job experience to pass the required
exams and move up to the OCP level.
Exam Requirements
Oracle9i Database: Fundamentals II (#1Z0-032):
- Networking Overview
- Explain solutions included with Oracle9i for managing complex networks
- Describe Oracle networking add-on solutions
- Basic Oracle Net Architecture
- Explain the key components of the Oracle Net layered architecture
- Explain Oracle Net Services role in client server connections
- Describe how web client connections are established through Oracle networking products
- Basic Net Server-Side Configuration
- Identify how the listener responds to incoming connections
- Configure the listener using Oracle Net Manager
- Control the listener using the Listener Control Utility (lsnrctl)
- Describe Dynamic Service Registration
- Configure the listener for IIOP and HTTP connections
- Basic Oracle Net Services Client-Side Configuration
- Describe the difference between host naming and local service name resolution
- Use Oracle Net Configuration Assistant to configure: Host Naming, Local naming method, Net service names
- Perform simple connection troubleshooting
- Usage and Configuration of the Oracle Shared Server
- Identify the components of the Oracle Shared Server
- Describe the Oracle Shared Server architecture
- Configure the Oracle Shared Server
- Identify and explain usefulness of related dictionary views
- Backup and Recovery Overview
- Describe the basics of database backup, restore and recovery
- List the types of failure that may occur in an Oracle environment
- Define a backup and recovery strategy
- Instance and Media Recovery Structures
- Describe the Oracle processes, memory structures, and files relating to recovery
- Identify the importance of checkpoints, redo log files, and
archived log files
- Describe ways to tune instance recovery
- Configuring the Database Archiving Mode
- Describe the differences between Archivelog and Noarchivelog modes
- Configure a database for Archivelog mode
- Enable automatic archiving
- Perform manual archiving of logs
- Configure multiple archive processes
- Configure multiple destinations, including remote destinations
- Oracle Recovery Manager Overview and Configuration
- Identify the features and components of RMAN
- Describe the RMAN repository and control file usage
- Describe channel allocation
- Describe the Media Management Library interface
- Connect to RMAN without the recovery catalog
- Configure the RMAN environment
- User-Managed Backups
- Describe user-managed backup and recovery operations
- Discuss backup issues associated with read tablespaces
- Perform closed database backups
- Perform open database backups
- Back up the control file
- Perform cleanup after a failed online backup
- Use the DBVERIFY utility to detect corruption
- RMAN Backups
- Identify types of RMAN specific backups
- Use the RMAN BACKUP command to create sets
- Back up the control file
- Back up the archived redo log files
- Use the RMAN COPY command to create image copies
- User-Managed Complete Recovery
- Describe media recovery
- Perform recovery in Noarchivelog mode
- Perform complete recovery in Archivelog mode
- Restore datafiles to different locations
- Relocate and recover a tablespace by using
archived redo log files
- Describe read-only tablespace recovery
- RMAN Complete Recovery
- Describe the use of RMAN for restoration and recovery
- Perform recovery in Noarchivelog mode
- Perform complete recovery in Archivelog mode
- Restore datafiles to different locations
- Relocate and recover a tablespace by using
archived redo log files
- User-Managed Incomplete Recovery
- Describe the steps of incomplete recovery
- Perform an incomplete database recovery
- Identify the loss of current online redo log files
- RMAN Incomplete Recovery
- Perform an incomplete database recovery using UNTIL TIME
- Perform an incomplete database recovery using UNTIL SEQUENCE
- RMAN Maintenance
- Perform cross checking of backups and copies
- Update the repository when backups have been deleted
- Change the availability status of backups and copies
- Make a backup or copy exempt from the retention policy
- Catalog backups made with operating system commands
- Recovery Catalog Creation and Maintenance
- Describe the contents of the recovery catalog
- Create the recovery catalog
- Maintain the recovery catalog by using RMAN commands
- Use RMAN to register, resynchronize, and reset a database
- Query the recovery catalog to generate reports and lists
- Create, store, and run scripts
- Describe methods for backing up and recovering the recovery catalog
- Transporting Data Between Databases
- Describe the uses of the Export and Import utilities
- Describe Export and Import concepts and structures
- Perform simple Export and Import operations
- List guidelines for using Export and Import
- Loading Data into a Database
- Demonstrate usage of direct- load insert operations
- Describe the usage of SQL*Loader
- Perform basic SQL*Loader operations
- List guidelines for using SQL*Loader and direct-load insert
|