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

11Managing Schema Objects

CERTIFICATION OBJECTIVES

11.01 Add and Modify Columns

11.02 Drop Columns and Set Column UNUSED

11.03 Add Constraints

11.04 Create Indexes Using the CREATE TABLE Statement

11.05 Create Function-Based Indexes

11.06 Perform FLASHBACK Operations

11.07 Create and Use External Tables

Image Two-Minute Drill

Q&A Self Test

This chapter looks at a variety of tasks, features, and SQL statements, all designed to support the management of database objects and the data contained within them using constraints and indexes in new ways, in new statements and new clauses and in new combinations. This chapter also introduces new features like ...

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