OCP 10G Exam 1Z0-043 (Oracle Database 10g: Administration II)

August 19, 2008 · Filed Under Certification  
Certification Name  : Oracle Database 10g Administrator
'                     Certified Professional (OCP 10g)
Exam Number         : 1Z0-043
Exam Price          : $125.00 USD
Duration            : 90 minutes
Number of Questions : 70
Passing Score       : 70%

Recommended Training:
Oracle Database 10g: Administration Workshop II

Exam Material

(The exam material is the same with Oracle Database 10g: Administration Workshop II training material):

  1. 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
  2. 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
  3. 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
  4. Dealing with Database Corruption
    • Define block corruption and list its causes and symptoms
    • Detect database corruptions using the following utilities: ANALYZE
  5. DBVERIFY
    • Detect database corruptions using the dbms_repair package
    • Implement the DB_BLOCK_CHECKING parameter to detect corruptions
    • Repair corruptions using RMAN
  6. 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
  7. 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
  8. 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
  9. 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
  10. 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
  11. 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
  12. 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
  13. 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
  14. 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
  15. 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

Tags: , , , , ,

Comments

Leave a Reply