Tag Archive | "Oracle certification exam 1z0-0032 tips"

Tags: ,

TIPS FOR ORACLE9i DBA EXAM 3 (#1Z0-032, Fundamentals II)

Posted on 29 May 2008 by Praveen

This exam focuses on three primary topics: basic Oracle Net configuration (in other words, configuring Oracle for network access), the skills that you use to protect and recover an Oracle database from the inevitable problems of data loss, and the Export/Import and SQL*Loader utilities. Expect to answer approximately 63 multiple choice questions in 90 minutes. To pass the exam, you need to answer at least 41 questions correctly (65%). Specifically, the exam tests you about the following categories of information:

 

  • the general need for Oracle Net, Oracle Corp.’s products that support applications in a networked environment
  • the benefits of Oracle Net
  • Oracle Net software architecture
  • Oracle Net name resolution methods (host naming, local naming, etc.)
  • shared server configuration and tuning
  • Oracle Net connection models (shared server, dedicated server, bequeathed, etc.)
  • Oracle Net disconnections
  • Oracle Net configuration files (sqlnet.ora, tnsnames.ora, listener.ora, etc.)
  • the TNS_ADMIN environment variable
  • network design
  • the Oracle Net Manager and Oracle Net Configuration Assistant
  • the purpose and configuration of a listener process
  • automatic service registration with the listener
  • static service registration with the listener
  • the Listener Control utility
  • transparent connection load balancing and failover
  • troubleshooting network connectivity problems
  • the TNSPING utility
  • failures that can damage an Oracle database system such as SQL statement failure, foreground and background process failure, system and instance crashes, disk (media) failures, and user errors
  • the roll forward (redo) and roll back (undo) recovery stages of crash, instance, and media recovery
  • the function of the database’s online log members, archived log files, and undo (rollback) segments in database recovery
  • configuration of the database’s online log groups and members, log archiving, checkpoints, and the control file
  • user-managed physical database backup and recovery using SQL commands and operating system commands
  • database backup and recovery using the Recovery Manager (RMAN) utility
  • logical database backup and recovery using the Import and Export utilities
  • detection and repair of data block corruption
  • bulk data loads of external data using the SQL*Loader utility
  • bulk data loads of internal data using direct-load INSERT statements

Comments (0)
Page 1 of 11