OCA: Oracle 10g Administration Study Guide
Chapter One
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.
* Describe a database transaction.
NOTE
Exam objectives are subject to change at any time without
prior notice and at Oracle's sole discretion. Please
visit Oracle' ... read full excerpt from OCA: Oracle 10g Administration I Study Guide : Exam 1Z0-042 ebook