Oracle® 9i SQL Exam Cram™ 2 (Exam 1Z0-007)

Chapter 12. Views, Indexes, Sequences, and Synonyms (DDL)

Terms You Need to Understand

• ✓ View

• ✓ Index

• ✓ Sequence

• ✓ Public synonym

• ✓ Private synonym

• ✓ Virtual column

Concepts You Need to Master

• ✓ Updatable views

• ✓ Constraint views

• ✓ Updating join subquery views

• ✓ Changing table data using updatable views

• ✓ The WITH CHECK OPTION for updatable views

• ✓ Changing views must account for all required (NOT NULL) columns in the underlying table (unless NOT NULL columns have DEFAULT settings)

• ✓ What virtual columns are and what causes them to be created

• ✓ Creating, altering, and dropping views

• ✓ Creating, altering, and dropping indexes

• ✓ Creating, altering, and dropping sequences

• ✓ Creating and dropping synonyms

This chapter describes views, indexes, sequences, and synonyms. ...