OCA Oracle Database 11g Administration I Exam Guide (Exam 1Z0-052)

9 Managing Schema Objects

CERTIFICATION OBJECTIVES

9.01 Create and Modify Tables

9.02 Manage Constraints

9.03 Create Indexes

9.04 Create and Use Temporary Tables

Two-Minute Drill

Self Test

Data in an Oracle database is stored in tables. Constraints, applied to tables, are the means whereby the database can implement some of the business rules defined by your business analysts. Indexes are required for enforcing some constraints, and necessary for performance reasons as well. Tables, constraints, and indexes are schema objects: they cannot exist ...