Oracle9i DBA New Features for Oracle7.3 and Oracle8 OCPs
 Printer View
|
|
| |
 |
| |
|
| Duration: |
120 minutes |
| Number of Questions: |
84 |
| Passing Score: |
69% |
|
Passing score subject to change. View Details
|
|
Recommended Training and Preparation
Additional Information & Resources
Exam Topics
Fraudulent Activity Policy
Recommended Training and Preparation
Instructor Led Training:
Oracle9i
Database: New Features for Administrators covers approximately 70% of the
exam topics. The training can be supplemented with self-study titles for Oracle8.0
to Oracle8i Upgrade Exam Prep.
Candidates wishing to prepare using only self-study materials will use two sets of titles: Oracle8.0 to Oracle8i Upgrade Exam Prep and Oracle9i New Features for Administrators Exam Prep.
Self-Study CD-ROMs are an excellent tool to help you prepare for your exam. SSCDs reinforce the course material and allow you to focus on sections that you need to review. Note: the SSCDs do not count towards your course requirements for certification and should be used as a study aid only.
Additional Information & Resources
Exam Topics
| Using
Partitioning: Conceptual Overview |
| [ ] |
Describe the general partioning rules |
| Implementing
Partitioned Indexes |
| [ ] |
Describe the different types of partitioned indexes |
| Supporting
Commands and Guidelines for Partitioned Tables and Indexes |
| [ ] |
Describe
restrictions that apply to certain operations |
| Parallelizing
INSERT, UPDATE, and DELETE Operations |
| [ ] |
Enable
parallel DML for a session |
| Identifying
New ROWID Structure |
| [ ] |
Describe
the new ROWID format |
| Managing
Large Objects |
| [ ] |
Differentiate between internal and external LOBs |
| Oracle
Universal Installer: Migration and Upgrade |
| [ ] |
Upgrade
a database to Oracle9i |
| Database
Resource Manager |
| [ ] |
Explain
the features of the database resource manager |
| Manageability
Enhancements |
| [ ] |
Relocate and reorganize tables |
| [ ] |
Remove
unused columns from a table |
| [ ] |
Define temporary tables |
| Availability
and Recoverability Enhancements |
| [ ] |
Implement
duplex and multiple archive logs |
| [ ] |
Describe
the functionality of LogMiner |
| [ ] |
Implement
fast-start fault recovery |
| [ ] |
Manage
corrupt block detection and repair |
| Online
Operations |
| [ ] |
Explain online index rebuild new functionality |
| [ ] |
Describe
online table redefinitions |
| [ ] |
Explain online analyze validate |
| [ ] |
Describe
the use of the Server Parameter File (SPFILE) |
| Segment
Management (Part I) |
| [ ] |
Use
the automatic global index maintenance feature |
| [ ] |
Explain
the use of external tables |
| [ ] |
Use
the new LIST partitioning method |
| [ ] |
Explain
the basics of meta data Application Programming Interface |
|
Segment Management (Part II) |
| [ ] |
Explain and use the new Automatic Segment-Space Management functionality
|
| [ ] |
Create and use bitmap join indexes |
|
Performance Improvements |
| [ ] |
Use the indexes monitoring feature |
| [ ] |
Describe
the cursor sharing enhancements |
| [ ] |
Identify cached execution plans |
| [ ] |
Gather
system statistics |
|
|
Implementing Oracle Advanced Queuing |
| [ ] |
Define
the advanced queuing concepts |
|
Using Additional New Features |
| [ ] |
Implement reverse key indexes |
| [ ] |
Create and use index-organized tables |
| Introduction
to Recovery Manager |
| [ ] |
Discuss
the benefits of using Recovery Manager |
| [ ] |
]
Identify the types of backups |
| Enhancements
to Networking |
| [ ] |
Describe the concept of multiplexing |
| [ ] |
Describe the concept of connection pooling |
| Implementing
Password Management |
| [ ] |
Implement password aging and expiry |
| SQL*Plus,
PL/SQL, and National Language Support Enhancements |
| [ ] |
Describe the use of PL/SQL for: Event Triggers, Autonomous Transactions,
Native Dynamic SQL |
| Database
Security |
| [ ] |
Implement
fine-grained access control |
|
Oracle Server Security |
| [ ] |
Explain the new privileged connection options |
| [ ] |
Describe the new security features and their application: Secure Application
Role, Global Context, Partitioned Fine Grain Access Control, Fine
Grained Auditing |
| General
High Availability Technology |
| [ ] |
Describe
fast-start time-based recovery limit |
| [ ] |
Explain
the new Oracle Flashback feature |
| [ ] |
Describe
Resumable Space Allocation |
| [ ] |
Describe
the new Export/Import features |
|
Real Application Clusters |
| [ ] |
Explain
Cache Fusion |
| [ ] |
Configure a shared server-side initialization parameter file
|
|
File Management |
| [ ] |
Explain the concept and benefits behind Oracle- Managed Files (OMF)
|
| [ ] |
Create and manage OMF files |
| [ ] |
Use
SQL syntax to remove associated OS files when removing a non-OMF tablespace
from the database |
| [ ] |
Create
and alter default temporary tablespaces |
| Tablespace Management |
| [ ] |
Explain the concept of Automatic Undo Management |
| [ ] |
Create
and maintain UNDO tablespaces |
| [ ] |
Create
and properly use multiple block sizes within a database |
| Memory Management |
| [ ] |
Set
parameters to enable automatic and dynamic sizing of SQL working areas
|
| [ ] |
Use new columns and views to gather information regarding SQL execution
memory management |
| [ ] |
Describe
the allocation and tracking of memory behind a dynamic SGA
|
|
| Optimizer
and Query Improvements |
| [ ] |
Describe
the features of optimizer plan stability |
| [ ] |
Explain
Top-N SQL queries |
| [ ] |
Explain
automatic parallel execution |
| Summary
Management |
| [ ] |
Build
and Manage Materialized views for Oracle Summaries |
| [ ] |
Build
and Manage Dimensions |
| Indexes
and Index-Organized Tables |
| [ ] |
Describe
a function-based index |
| Partitioning
Improvements |
| [ ] |
Implement
range, hash, and composite partitioning |
| [ ] |
Describe partition-wise join |
| LOBs
|
| [ ] |
Define
LOBs from a DBA perspective |
| Oracle9i
LogMiner Enhancements |
| [ ] |
Explain
LogMiner new features: DDL statement support, dictionary staleness
detection, ability to use an online dictionary, ability to skip log
corruptions |
| Backup
and Recovery |
| [ ] |
Describe
new RMAN manageability features: new backup enhancements, new restore/recovery
enhancements |
| [ ] |
Describe
new RMAN reliability features: Block media recovery (BMR), Trial Recovery
|
| [ ] |
Describe
other RMAN improvements |
| Oracle9i
Data Guard |
| [ ] |
Explain the Oracle9i Data Guard Architecture |
| [ ] |
Configure the physical Standby Database in no-data- loss mode |
| ] |
Initiate
a Database Switchover operation |
| Database
Resource Manager Enhancements |
| [ ] |
Automatically detect long running operations |
| [ ] |
Automatically limit resource consumption other than CPU and DOP |
| Enterprise Manager Enhancements
|
| [ ] |
Generate
HTML Reports |
| [ ] |
Create
User defined events |
| SQL
Enhancements |
| [ ] |
Use ISO/ANSI standard SQL syntax, such as: Joins, CASE expressions,
NULLIF, COALESCE, scalar subqueries, MERGE, analytical functions |
| [ ] |
Identify
other SQL enhancements, such as: constraint enhancements, FOR UPDATE
WAIT |
| [ ] |
Use
the enhancements to LOBs and PL/SQL |
| Globalization Support
|
| [ ] |
Describe
the new date and time data types |
| [ ] |
Describe the Unicode enhancements |
| [ ] |
Use
the Character Set Scanner |
|
Database Workspaces |
| [ ] |
Version-enable a table |
| [ ] |
Create and assign a workspace |
|
Oracle Certification Program Fraudulent Activity Policy
Oracle reserves the right to take action against any candidate involved in fraudulent activities, including, but not limited to, fraudulent use of vouchers, promotional codes, reselling exam discounts and vouchers, cheating on an exam, alteration of score reports, alteration of completion certificates, violation of exam retake policies or other activities deemed fraudulent by Oracle.
If Oracle determines, in its sole discretion, that fraudulent activity has taken place, it reserves the right to take action up to and including, but not limited to, decertification of a candidate's Oracle Certified Associate, Oracle Certified Professional and/or OCM credentials, temporary, indefinite or permanent ban of a candidate from Oracle certification programs, notification to a candidate's employer, and notification to law enforcement agencies. Candidates found committing fraudulent activities forfeit all fees previously paid to Oracle, or to Oracle's authorized vendors, and may be required to pay additional fees for services rendered.