Nearly eighty objectives have been specified for 1Z0-031 (Oracle9i Database: Fundamentals I) test. This clearly indicates that a candidate should have a sound knowledge about Oracle’s architectural components and database structure before taking the test. One should also be capable of managing storage structures within a database in order to keep the database up to date. Practicing the following things can help a candidate clearly understand these points and pass the test confidently:
Pass OCA DBA 9i certification exam in first attempt. Download latest exam simulation, questions, tutorial and study guide for OCA DBA 9i:
- Pass one of the following entry level exams:
- 1Z0-007 Introduction to Oracle9i: SQL
- 1Z0-047 Oracle Database SQL Expert
- 1Z0-051 OCA: Oracle Database 11g-SQL Fundamentals-I
- Pass the following core exam:
- 1Z0-031 Oracle9i Database: Fundamentals I
- Install and uninstall Oracle by using Oracle Universal Installer (OUI).
- Create a password file and set up password file authentication for administrative users.
- Create an initialization parameter file.
- Start up and shut down an Oracle instance.
- Create a database by using the Database Configuration Assistant (DBCA).
- Create a database manually.
- Multiplex control files and online redo log files.
- Create locally-managed and dictionary managed permanent and temporary tablespaces.
- Change the size of a permanent tablespace by adding data files to it.
- Implement automatic undo management by creating an undo tablespace.
- Create, alter, reorganize, truncate, and drop a table.
- Create, reorganize, and drop various types of indexes.
- Create various types of constraints and enable and disable constraint checking.
- Create, alter, and drop database users.
- Create and remove roles and profiles.
- Grant and revoke privileges from database users and roles.
- Use different types of National Language Support (NLS) parameters.
>
