Exam 8: Advanced Table Management

When using transparent table encryption,a random string called a ____ string is added to the column in clear text prior to encryption.

What are the primary advantages and disadvantages of an index-organized table?

By default the CASCADE CONSTRAINTS and PURGE option are included in a DROP TABLE.

Upgrading a table structure causes any object types used in the table to be updated with the most recent version of the object type definition.

The large majority of relational data is stored in ____________________-organized tables because it is the default format used by Oracle 10g for relational tables (and for many other database engines).

An index-organized table does not have an index.

Large-sized files can be loaded into a(n)____________________ record in the database,where they are protected from unauthorized use and possible theft or damage.

Sometimes,Oracle 10g stores an internal LOB's value within the row (____).

The LOB datatypes are divided into ____ groups,according to where they are stored.

You can partition index-organized tables,but only using ____________________ or range partitioning.

The large majority of relational data is stored in ____ tables.

The DBA_RECYCLEBIN and ____________________ metadata views can be used to display the contents of all recycle bins,for all users,or a specifically connected user recycle bin.

Why should you periodically analyze tables in a schema?

When creating a relational table with a BLOB column,the ____ parameter sets the number of bytes allocated for working with the LOB value.

When dropping a table it will automatically be saved in the Oracle 10g database recycle bin.

When storing LOB values out of line,Oracle 10g allocates space by data blocks,rather than by chunks.

To analyze a table,you can use either the ____________________ command or the DBMS_STATS predefined package.

An index-organized table indexes all columns in a table.

____________________-based optimization uses statistics on the actual volume and distribution of table data to determine the best path to retrieve the data,taking into account the relative costs of I / O,CPU time,execution time,and other factors.

The BFILE data is stored inside the database.