Exam 8: Advanced Table Management

SCN stands for ____________________.

Oracle 10g introduced encryption of data within the confines of an Oracle database,preventing potential snooping into datafiles from outside the confines of Oracle database software.

Because of their potentially huge size,Oracle 10g has special storage methods for LOBs.

You can remove all the rows in a table without generating redo log entries by using the ____________________ command.

Procedures and functions in the DBMS_LOB package are all standard programming structures,used to open,close,read,and write files,along with various other activities.

A query ____________________ is a list of steps taken to retrieve data for a query.

A relational table with a primary key constraint automatically has a unique ____________________ associated with the primary key.

The NCLOB datatype is equivalent to the CLOB datatype,but for using ____.

If you are sure you do not need the data and want to remove thousands or millions of rows quickly,you can use the ____ command.

The high ____________________ is the boundary between used data blocks and unused data blocks in a table.

VARRAYs LOB can be in a different tablespace than the table.

An example of a ____ table could be a table used to look up the population of a city by its state,county,and municipal code.

There is a special ____ package called DBMS_LOB,used to simplify the manipulation of data in LOB columns.

Moving a row changes its ROWID.

Index-organized tables tend to have smaller-sized rows (than tables with LOBs)that benefit from a consolidation of the table's ____________________ storage and the table's data storage.

Many portions of the storage structure of a table can be modified after the table is created.

A good use for index-organized tables is a table in which most of the columns are indexed within the primary key of the table and the data that is not part of the primary key is relatively small and static.

When you set ____ for a table,data blocks read are placed in the "most recently used" section of the buffer.

Unless you specify that all LOB values must be stored out of line,Oracle 10g stores LOB values that are less than ____-byte-long inline.

You can remove all the table's rows along with the table structure by using the ____________________ TABLE command.