Exam 7: Basic Table Management

____________________ partitioning uses a hashing algorithm to spread table rows evenly across separate physical files in the database.

A(n)____________________ partition allows splitting of data based on ranges of values within a table's rows.

If a row is updated and requires more free space than the block contains,the entire row is ____________________,that is,moved to another block.

There are two formats for the physical ROWID: extended ROWID and ____ ROWID.

You can partition any table except one that is part of a ____.

What is XML?

A table ____________________ is a shortcut name for a table used to prefix columns in an SQL command in place of using the entire table name.

With ____ partitioning,you are actually partitioning the data and then partitioning the data within each partition.

The ____ datatype stores pointers to an external file,such as an audio track.

The ____________________ datatype stands for universal ROWID datatype,and it can hold any type of ROWID,including a record identifier from a non-Oracle database.

The ____ of a data block shrinks as rows are inserted or updated with more data,causing both the row directory and the row data to consume more space.

A subpartition ____________________ describes all the subpartitions once and then all the partitions that use it.

Partitioned tables can store each partition in a separate tablespace.

A(n)____________________ acts like a column in a query,but is actually calculated by the database a query is executed.

Two sessions cannot use the same temporary table at the same time.

A ____ contains the physical or logical address of the row.

When you create a table you cannot define the storage settings of the table.

A(n)____________________ value is a value that is filled into the column when an inserted row does not specify the value for that column.

The default value for INITRANS is 1 for tables and ____ for indexes.

A table created with one column of the XMLtype datatype is a(n)____________________ table.