Exam 7: Basic Table Management

A null column followed by one or more columns with data must have a placeholder.

A(n)____________________ process automatically calculates the best way to execute a query.

For a locally managed tablespace with uniform extent size,storage settings such as NEXT will be ignored when overridden for a table in that tablespace.

All tables must have a primary key.

In an index-organized table the entire table is an index.

You must create an object type that has the design you want to use for your object table before actually creating the object table.

The default block size is ____ bytes,determined on database creation.

Unlike working with permanent tables,adding or changing data in a temporary table does not generate undo log entries;however,it does generate redo log entries.

Access by ROWID is probably the fastest and most reliable method of data retrieval.

____ tells Oracle 10g how much free space to reserve for updates to existing rows.

A(n)____ is a calculation producing an integer for a particular value of a string.

The ____ is a list of row identifiers for rows stored in a data block.

Clusters speed up the access to sets of tables that are frequently referenced together.

The traditional way of looking at metadata is using metadata and data dictionary views.

When you create a table,you define the table's name as well as each column's name,____________________,and size.

When a row is dropped in a table,the row directory shrinks.

A table can contain zero or more columns.

Clusters store data of multiple tables in one ____.

A row that spans multiple blocks is called a multi-row.

The user-defined datatype can be any collection of the other datatypes you want assembled into its own datatype.