OCA Oracle Database 11g SQL Fundamentals I Exam Guide

CERTIFICATION OBJECTIVES

12.01    Create Simple and Complex Views

12.02    Retrieve Data from Views

12.03    Create Private and Public Synonyms

12.04    Create, Maintain, and Use Sequences

12.05    Create and Maintain Indexes

           Two-Minute Drill

Q&A      Self Test

 

So far, most of the SQL statements used in this book have addressed tables. This seems reasonable: SQL commands interact with data, and data is stored in tables. In practice, most users never issue SQL that addresses tables: they issue SQL that addresses views or synonyms. Views ...