O'Reilly logo

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

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

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

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