O'Reilly logo

OCA Oracle Database SQL Exam Guide (Exam 1Z0-071) by Steve O'Hearn

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

Images

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

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