Course in Oracle 9i DBA Fundamentals - 1 (Paper 3)

A Database Administrator's (DBA) role is of paramount importance since it deals with critical issues of database design and management. This paper gives a firm foundation in basic database tasks. By the end of this segment, students will be able to design, create and maintain an Oracle database.

After the completion of this course, the student will be able to:

* Describe the Oracle architecture
* Identify the features of the Oracle Universal Installer
* Explain the start-up and shutdown of an Oracle instance
* Describe the process of database creation
* Explain data dictionary and dynamic performance views
* Explain control file and redo log files
* Explain managing tablespaces and datafiles
* Describe the different types of indexes and their uses
* Explain resource management and privileges
* Explain auditing
* Describe globalisation support in Oracle