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

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.

Start your free trial