Oracle 9i Fundamentals I Exam Cram™ 2 (Exam 1Z0-031)

Chapter 12. Managing Tables

Terms you'll need to understand:

• External tables

• Partitioned tables

• Cluster tables

• Regular tables

• Index-organized tables

• Truncate

• ALTER TABLE

• Scalar data types

• User-defined data types

• LOBs

• ROWID

Concepts you'll need to master:

• Identify the various methods of storing data.

• Identify Oracle data types.

• Distinguish between extended and restricted ROWID.

• Identify the structure of a row.

• Create regular and temporary tables.

• Manage the storage structures within a table.

• Reorganize, truncate, and drop tables.

• Drop columns within a table.

• Rename a column within a table.

• Move tables from one tablespace to another.

As a database administrator, you will likely spend a considerable amount of time managing tables or managing objects surrounding tables. ...