Chapter 7. Creating Schema Objects

ORACLE DATABASE 11g: SQL FUNDAMENTALS I EXAM OBJECTIVES COVERED IN THIS CHAPTER:

  • Creating Other Schema Objects

    • Create simple and complex views

    • Retrieve data from views

    • Create, maintain, and use sequences

    • Create and maintain indexes

    • Create private and public synonyms

Creating Schema Objects

An Oracle database can contain far more objects than simply tables. Chapter 6, "Creating Tables and Constraints," gave you an overview of all the major objects that can be in an Oracle schema. In this chapter, you will learn in detail some of the schema objects, concentrating of course on the OCP certification exam objectives. You will be learning about creating ...

Get OCA Oracle® Database 11g Administrator Certified Associate: Study Guide now with O’Reilly online learning.

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