O'Reilly logo

OCA/OCP Oracle Database 11g All-in-One Exam Guide with CD-ROM : Exams 1Z0-051, 1Z0-052, 1Z0-053 by Bob Bryla, Roopesh Ramklass, John Watson

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

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

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