Exam 7: Basic Table Management

A ____ stores the number of columns contained in the column data area,some overhead,and the ROWID pointing to a chained or migrated row (if any).

A(n)____ ROWID identifies a row by its primary key in an index-organized table.

The ____ datatype contains valid dates that range from January 1,4712 B.C.to December 31,9999 A.D.

A nested table is a fixed length array,such that the number of elements is known,and relatively constant.

The default display format for DATE is ____.

____________________ tables are read-only,require read and write privileges in the directory created within,and can be created and loaded using an AS subquery clause.

____ are programmed processes stored with the object type's definition.

Locally managed tablespaces handle free space using a bitmap within the tablespace.

The ____ are bytes of storage used for rows inserted or updated in a data block.

To create a partitioned table,you use the standard CREATE TABLE command as if you were creating a relational table,and add the ____________________ clause.

An object table row is also called an object table ____________________.

Technically,a ____ is not a table,but a group of tables stored together as if they were one table.

A ____ is a special type of ROWID for clustered tables.

LRU stands for ____________________.

Nested table rows are associated with a row in the ____________________ table by the nested table identifier.

LOB stands for ____________________.

A nested table must contain a single column of either a built-in data type,or a collection type data type.

What is an object type?

Tables are made up of rows and ____________________.

SQL*Plus is limited in its ability to execute high-level database administration functionality,such as starting up and shutting down a database.