10Creating Other Schema Objects

CERTIFICATION OBJECTIVES

10.01 Create and Use Simple and Complex Views

10.02 Create, Maintain, and Use Sequences

10.03 Create and Maintain Indexes

10.04 Create Private and Public Synonyms

Image Two-Minute Drill

Q&A Self Test

This chapter introduces a number of other schema objects that are necessary to understand in order to create a complete application. These objects include the view, sequence, index, and synonym. Each is uniquely important in a variety of ways.

CERTIFICATION OBJECTIVE 10.01Create and Use Simple and Complex Views

A view is a SELECT statement with a name, stored in the database, and accessible as though ...

Get OCA Oracle Database SQL Certified Expert Exam Guide (Exam 1Z0-047) now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.