OCA: Oracle 10g™ Administration I: Study Guide

Chapter 1. Oracle Database 10g Components and Architecture

ORACLE DATABASE 10G: ADMINISTRATION I EXAM OBJECTIVES COVERED IN THIS CHAPTER:

• Installing Oracle Database 10g Software

  • Identify system requirements.

  • Use Optimal Flexible Architecture.

  • Install software with Oracle Universal Installer.

  • Identify and configure commonly used environment variables.

• Creating an Oracle Database

  • Explain the Oracle database architecture.

  • Explain the instance architecture.

• Database Interfaces

  • Use SQL*Plus and iSQL*Plus to access the Oracle Database 10g.

  • Use SQL*Plus and iSQL*Plus to describe the logical structure of tables.

  • Use SQL to query, manipulate, and define data using SELECT, UPDATE/INSERT/DELETE and CREATE/ALTER/ DROP statements.

  • Identify common database interfaces. ...