Things to practice for Oracle test 1Z0-031.

Things to practice for Oracle test 1Z0-031.

Rating:

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:

1. Install and uninstall Oracle by using Oracle Universal Installer (OUI).


2. Create a password file and set up password file authentication for administrative users.


3. Create an initialization parameter file.


4. Start up and shut down an Oracle instance.


5. Create a database by using the Database Configuration Assistant (DBCA).


6. Create a database manually.


7. Multiplex control files and online redo log files.


8. Create locally-managed and dictionary managed permanent and temporary tablespaces.


9. Change the size of a permanent tablespace by adding data files to it.


10. Implement automatic undo management by creating an undo tablespace.


11. Create, alter, reorganize, truncate, and drop a table.


12. Create, reorganize, and drop various types of indexes.


13. Create various types of constraints and enable and disable constraint checking.


14. Create, alter, and drop database users.


15. Create and remove roles and profiles.


16. Grant and revoke privileges from database users and roles.


17. Use different types of National Language Support (NLS) parameters.

Rating: