OCA Oracle Database SQL Exam Guide (Exam 1Z0-071)

10

Managing Schema Objects

CERTIFICATION OBJECTIVES

10.01     Describe How Schema Objects Work

10.02     Create Simple and Complex Views with Visible/Invisible Columns

10.03     Create, Maintain, and Use Sequences

10.04     Create and Maintain Indexes Including Invisible Indexes and Multiple Indexes on the Same Columns

10.05     Perform Flashback Operations

     ✓   Two-Minute Drill

Q&A     Self Test

In addition to tables, there are other important schema objects. This chapter looks at several, including views, sequences, and indexes. This chapter also addresses additional features: Flashback Table, Flashback Drop, and Flashback Query.

CERTIFICATION ...