OCA Oracle Database SQL Exam Guide (Exam 1Z0-071)

2

Using DDL Statements to Create and Manage Tables

CERTIFICATION OBJECTIVES

2.01     Categorize the Main Database Objects

2.02     Create a Simple Table

2.03     Review the Table Structure

2.04     List the Data Types That Are Available for Columns

2.05     Explain How Constraints Are Created at the Time of Table Creation

2.06     Drop Columns and Set Columns UNUSED

2.07     Create and Use External Tables

   ✓        Two-Minute Drill

Q&A     Self Test

This chapter begins to examine tables. Tables are database objects that programmers create to store the data that populates the database.

CERTIFICATION OBJECTIVE 2.01

Categorize the Main Database ...