Chapter 9

Give three criteria for when a column should be indexed.

Describe referential integrity.

Explain how Oracle uses declarative referential integrity to prevent deletion, insertion, and update problems.

Explain how normalizing a database to the third normal form affects database performance.

Chapter 10

Describe how each of these types of constraints restricts the values that can be stored in a table: not null, unique, primary key, foreign key, and check.

Describe the difference between a column-level constraint and a table-level constraint.