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.
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's Training and Certification website (http://www.oracle.com/education/certification/) for the most current exam objectives listing.
With the release of Oracle Database 10 g (Oracle 10 g ), Oracle Corporation has delivered a powerful and feature-rich database that can meet the performance, availability, recoverability, and security requirements of any mission-critical application. As the Oracle DBA, you are responsible for managing and maintaining the Oracle 10 g database from initial installation, creation, and configuration to final deployment. Performing these tasks requires a solid understanding of Oracle's product offerings so that you can apply the proper tools and features to the application. You must also use relational database concepts to design, implement, and maintain the tables that store the application data. At the heart of these activities is the need for a thorough understanding of the Oracle architecture and the tools and techniques used to monitor and manage the components of this architecture.
This chapter introduces you to important concepts associated with the relational nature of Oracle 10g and its architecture. This chapter will also help you learn the specifics of how to install, configure, and manage an Oracle database. You need a solid understanding of these concepts before moving on to subsequent chapters.