O'Reilly logo

OCA: Oracle 10g™ Administration I: Study Guide by Matthew Weishan, Joseph C. Johnson, Bob Bryla, Chip Dawes

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required