O'Reilly logo

OCA Oracle Database SQL Exam Guide (Exam 1Z0-071) by Steve O'Hearn

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

Images

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

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