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:
- Setting up password file authentication for administrative users.
- Using Oracle Enterprise Manager (OEM) and its components.
- Creating and managing initialization parameter files.
- Implementing Oracle Managed Files (OMF).
- Starting up and shutting down an Oracle instance.
- Creating a database manually and by using Database Configuration Assistant (DBCA).
- Querying data dictionary.
- Multiplexing and managing control files and online redo log files.
- Creating and altering tablespaces.
- Implementing automatic undo management.
- Creating and altering regular and temporary tables and managing storage structures within them.