OCA: Oracle 10g™ Administration I: Study Guide

Chapter 3. Database Storage and Schema Objects

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

• Storage Structures

  • Define the purpose of tablespaces and data files.

  • Create tablespaces.

  • Manage tablespaces (alter, drop, generate DDL, take offline, put on line, add data files, make read-only/read-write).

  • Obtain tablespace information from EM and the data dictionary.

  • Drop tablespaces.

  • Describe the default tablespaces.

• Managing Schema Objects

  • Create and modify tables.

  • Define constraints.

  • View the attributes of a table.

  • View the contents of a table.

  • Create indexes and views.

  • Name database objects.

  • Select appropriate data types.

  • Create and use sequences.

NOTE

Exam objectives are subject to change at any time without prior notice and ...