Exam 7: Basic Table Management

To use ____ partitioning,you set up a distinct list of partitioning key values and define which values go into each partition.

A query cannot execute against a single partition.

A(n)____ table is the standard table traditionally used in a relational database.

The CREATE ____ command is used to create a temporary table.

____ tells Oracle 10g when to allow more rows to be inserted into the block after the deletion of rows from a block.

One ____ in a row contains one field of data for one record.

It is generally better to keep extent sizes the same or multiples of the same size within the ____ so that any deallocated free space can be more readily used later on.

____ tables contain data that is stored within a single column of another table.

A table resides in a single tablespace unless it is ____________________.

Each ____ represents a group of bytes in the physical file.

The ____ contains information about the table that has data in a particular data block.

Chaining and migrating of row data increases database performance.

The ____ is a new Oracle 10g feature for deleting objects but allowing for later retrieval.

The two types of embedded tables are called VARRAYs and ____ tables.

One ____ in a table contains data for one record.

A chained or migrated row is located by the ____________________ stored in the row header.

____ are rules that define data integrity for a column or group of columns.

A(n)____ is a column or set of columns that uniquely identify each row.

A(n)____________________ stores data of all types and is the most common form of storage in the database.

The ____ datatype is a text string with variable length up to 4000 bytes.