Exam 8: Advanced Table Management

The BFILE datatype is a(n)____ LOB.

A(n)____________________ with LOB columns can store huge amounts of data in a single column.

There is more to the FLASHBACK TABLE command than simply recovering tables from the recycle bin.

When deallocating space,the data blocks that are below the high watermark are released back to the database.

There is now only one type of optimizer available to Oracle 10g: ____-based optimization.

The ____ datatype is for pointers to an externally stored multimedia file.

Subjected to constant DML change activity,an index-organized table will deteriorate more rapidly than a regular BTree index.

The LOGGING clause suppresses the creation of redo log entries for some DDL commands,and some DML commands against the table,and for mass insert commands,such as those run by SQL*Loader.

The pointer that directs the database to the actual location of the value is called the ____ locator for external LOBs.

A LOB column has one of ____ datatypes.

A(n)____ table is a relational table with a primary key,in which the rows are stored physically in order of the primary key.

When little or no down time is available for database maintenance,you can use the DBMS_REDEFINTION for tables in the high-demand system.

It is a prerequisite for efficiency that an index-organized table contain only static data.

____ was created for high-availability applications,such as online airline reservations or online banking services.

A BTree index balances data in even branches that split into narrowing ranges of key values.

External LOBs use ____ semantics.

Internal LOBs use ____ semantics.

The CREATE TABLE and ALTER TABLE commands can both be used to encrypt table data at the column level.

LONG and ____________________ are deprecated.

How can you decide what chunk size to use when creating a relational table with a BLOB column?