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.
- Creating, reorganizing, and dropping various types of indexes.
- Implementing and maintaining data integrity constraints.
- Managing passwords and database resources by using profiles.
- Creating, altering, and dropping database users.
- Granting and revoking privileges from database users.
- Creating, modifying, and removing roles.
- Using different types of National Language Support (NLS) parameters.