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

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