How to prepare for 1Z0-031 exam.

Oracle has specified more than seventy-five objectives for 1Z0-031 (Oracle9i Database: Fundamentals I) test, which are grouped under eighteen topics. Before taking the test, one should have good command over the following areas:

  1. Setting up password file authentication for administrative users.
  2. Using Oracle Enterprise Manager (OEM) and its components.
  3. Creating and managing initialization parameter files.
  4. Implementing Oracle Managed Files (OMF).
  5. Starting up and shutting down an Oracle instance.
  6. Creating a database manually and by using Database Configuration Assistant (DBCA).
  7. Querying data dictionary.
  8. Multiplexing and managing control files and online redo log files.
  9. Creating and altering tablespaces.
  10. Implementing automatic undo management.
  11. Creating and altering regular and temporary tables and managing storage structures within them.
  12. Continue reading “How to prepare for 1Z0-031 exam.”