O'Reilly logo

OCA Oracle Database SQL Expert Exam Guide 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

2Using 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

image Two-Minute Drill

Q&A Self Test

This chapter begins to examine the building blocks of a SQL database, which are the objects inside the database that programmers create to store the data that populates the database.

CERTIFICATION OBJECTIVE 2.01Categorize the Main Database Objects

Database objects are the foundation of any database application. 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