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

image Two-Minute Drill

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

Get OCA Oracle Database 11g Administration I Exam Guide (Exam 1Z0-052) now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.