Chapter 11. Tables, Datatypes, and Constraints (DDL)
Terms You Need to Understand
✓ Table
✓ Datatype
✓ Constraint
✓ Index
✓ View
✓ Index Organized Table (IOT)
✓ Cluster
✓ Materialized view
✓ Sequence
✓ Synonym
✓ Partition
✓ DEFAULT
✓ VARRAY
✓ Nested table
✓ Inline constraint
✓ Out-of-line constraint
✓ NOT NULL constraint
✓ Check constraint
✓ Primary key constraint
✓ Foreign key
✓ ENABLE or DISABLE
✓ VALIDATE and NOVALIDATE
Concepts You Need to Master
✓ Oracle built-in datatypes
✓ User-defined datatypes
✓ Constraint states
✓ Creating tables
✓ Altering tables
✓ Dropping, truncating, and renaming tables
✓ Tables, columns, datatypes, and constraints and how they relate to each other
This chapter examines the details of table creation and maintenance plus use of column datatypes ...
Get Oracle® 9i SQL Exam Cram™ 2 (Exam 1Z0-007) 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.
