Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003

    Unanswered: Question on 1z0-032 What topics we should read

    I am reading OCP book published by 'sybex' for 1z0-032.
    I got a TK dump from some group. I found out that the
    material covered in the 'sybex' publication is mush different
    than the questions in TK.
    for example .. hsese are few questions from TK
    - standby db
    - tuning SGA
    - cache fusion
    - dbms_stats features
    .... looks like mostly the new9i features
    the topics covered the book are
    newworking/bkp-recovery/shared server/imp-exp/sql*loader etc

    My question is :
    what topics I should read to prepare for this 032 exam

    I appreciate your input.

  2. #2
    Join Date
    Jul 2003
    Why not go straight to ORACLE to get this information??

    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

    - The_Duck
    you can lead someone to something but they will never learn anything ...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts