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

Get OCA Oracle Database SQL Certified Expert Exam Guide (Exam 1Z0-047) now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.