This website provides targeted information for you searches. Trust the #1 resource for certification information that thousands have come to rely upon for great resources, all at a low price.

Exam Topics

Java in the Database
[ ] Describe Oracle java components
[ ] Describe JServer installation
[ ] Tune JServer

Optimizer and Query Improvements
[ ] Describe the features of optimizer plan stability
[ ] Describe the contents of the DBMS_STATS Package
[ ] Explain Top-N SQL queries
[ ] Identify new SQL keywords for computing subtotals
[ ] Identify new sort processing options
[ ] Explain automatic parallel execution

Summary Management
[ ] Build and Manage Materialized views for Oracle Summaries
[ ] Build and Manage Dimensions

Indexes and Index-Organized Tables
[ ] Describe bitmap indexes improvements
[ ] Describe a function-based index
[ ] Build an index online
[ ] Compute index statistics
[ ] Describe an index-organized table (IOT)
[ ] Explain logical ROWIDs
[ ] Create multiple indexes on an IOT
[ ] Explain how to partition an IOT

Partitioning Improvements
[ ] Revise the general partitioning concepts
[ ] Implement range, hash, and composite partitioning
[ ] Explain ENABLE/DISABLE ROW MOVEMENT
[ ] Explain the new partition pruning capabilities
[ ] Describe partition-wise join
[ ] Review partition maintenance operations

Object Relational Features and LOBs
[ ] Define LOBs from a DBA perspective

Oracle Universal Installer: Migration and Upgrade
[ ] List the features of the Oracle Universal Installer
[ ] Migrate an Oracle7 database to Oracle8i
[ ] Upgrade an Oracle8 database to Oracle8i

Tablespace Management
[ ] Manage locally managed tablespaces
[ ] Manage transportable tablespaces
[ ] Use read-only tablespace enhancements

Database Resource Manager
[ ] List the features of the database resource manager
[ ] Limit the use of resources using the database resource manager

Manageability Enhancements
[ ] Identify database limits
[ ] Relocate and reorganize tables
[ ] Remove unused columns from a table
[ ] Define temporary tables
[ ] Identify SQL*Loader enhancements
[ ] Monitor long-running operations
[ ] Define new constraints features
[ ] Define new Export/Import features

Availability and Recoverability Enhancements
[ ] Learn RMAN new features
[ ] Implement duplex and multiple archive logs
[ ] Set up a standby database in sustained recovery mode
[ ] Start up a database for read operations
[ ] Suspend database I/Os
[ ] Describe the funtionality of LogMiner
[ ] Implement fast-start fault recovery
[ ] Manage corrupt block detection and repair
[ ] Describe the new possibility of dynamically changing the number of free lists

Features of NET8
[ ] Describe the new service naming scheme
[ ] Explain automatic registration
[ ] Describe load balancing
[ ] Configure the network for JServer

SQL*Plus, PL/SQL, and National Language Support Enhancements
[ ] Use SQL*Plus for database management
[ ] Describe the use of PL/SQL for: Event Triggers, Autonomous Transactions, Native Dynamic SQL

Database Security
[ ] Describe N-Tier authentication
[ ] Describe invoker's rights security management
[ ] Implement application context areas
[ ] Implement fine-grained access control

Other related Resources at Actualtests.com

We hope you take advantage of the unlimited access package today. Your query about Oracle Exam Information - ActualTests.com can also be answered if you become a member today. We have all the details in the member zone. You can also download a testing engine for the most popular exams alogwith all the PDF's. They're all included in the package.

Check the MCSE Training page also if you are interested in that certification.