Exam 8: Advanced Table Management

The BLOB,CLOB,and NCLOB datatypes are called ____________________ LOBs.

Index-organized tables help you query table rows more quickly by reducing the number of times a process must read either memory or disk to retrieve the row data,when rows are read according to the ____.

If you copy an external LOB from one row or column to another,the entire LOB-including its data-is copied to the new location.

The USER_TAB_PRIVS_MADE dictionary view lists table privileges granted by the current user on tables owned by the current user

Executing a(n)____________________ command that removes all the table's rows causes Oracle 10g background processes to write undo records and redo log entries for each row deleted.

When an internal LOB is stored out of line,a separate LOB data ____________________ is created.

In an index-organized table every row is stored in a(n)____ index structure.

From a performance tuning perspective,caching LOB objects is not sensible unless your application uses very small objects,such as iconic images.

You cannot include LOB columns in index-organized tables.

Give examples of uses of LOB columns.

The BLOB datatype is a binary ____________________.

It is possible to remove all the rows from a table by typing: ____ FROM <tablename>;

A dropped table,saved to the recycle bin,can be recovered to its state prior to being dropped using a(n)____________________ TABLE command.

The index of a relational table is stored in primary key order in a(n)____________________ index structure,making queries by primary key very fast.

When copying an external LOB,only the pointer to the location of the file is actually copied;the original file is not copied.

Oracle 10g has a feature called _________________________,allowing you to make nearly any change to a table you need,while keeping the table available for inserts and updates most of the time.

The CLOB datatype is a(n)____________________ large object,for storing text strings.

You should use LOB storage for VARRAYs,when the VARRAY is intended to be very large.

Object tables and object-type columns are based on the definition of a(n)____________________.

When creating a relational table with a BLOB column,naming the LOB data segment is optional.