OCA/OCP Oracle Database 11g All-in-One Exam Guide

CHAPTER 7DDL and Schema Objects

Exam Objectives

In this chapter you will learn to

• 051.10.1 Categorize the Main Database Objects

• 051.10.2 Review the Table Structure

• 051.10.3 List the Data Types That Are Available for Columns

• 051.10.4 Create a Simple Table

• 051.10.5 Explain How Constraints Are Created at the Time of Table Creation

• 051.10.6 Describe How Schema Objects Work

• 052.8.1 Create and Modify Tables

• 052.8.2 Manage Constraints

• 052.8.3 Create Indexes

• 052.8.4 Create and Use Temporary Tables

• 051.11.1 Create Simple and Complex Views

• 051.11.2 Retrieve Data from Views

• 051.11.3 Create, Maintain, and Use Sequences

• 051.11.4 Create and Maintain Indexes

• 051.11.5 Create Private and Public Synonyms

In terms of the sheer number ...