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

Get OCA: Oracle 10g™ Administration I: Study Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.