Question 1

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

Accepted Answer

The answer of Object tables and object-type columns are based...

Question 2

SCN stands for ____________________.

Accepted Answer

The answer of SCN stands for ____________________....

Question 3

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

Accepted Answer

The answer of A relational table with a primary key...

Question 4

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

Accepted Answer

The answer of You can remove all the rows in...

Question 5

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).

Accepted Answer

The answer of The large majority of relational data is...

Question 6

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

Accepted Answer

The answer of When an internal LOB is stored out...

Question 7

LONG and ____________________ are deprecated.

Accepted Answer

The answer of LONG and ____________________ are deprecated....

Question 8

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

Accepted Answer

The answer of A query ____________________ is a list of...

Question 9

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

Accepted Answer

The answer of To analyze a table,you can use either...

Question 10

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.

Accepted Answer

The answer of Index-organized tables tend to have smaller-sized rows...

Question 11

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.

Accepted Answer

The answer of Executing a(n)____________________ command that removes all the...

Question 12

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

Accepted Answer

The answer of You can partition index-organized tables,but only using...

Question 13

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

Accepted Answer

The answer of You can remove all the table's rows...

Question 14

A non index-organized table is also called a heap-organized or ____________________ table.

Accepted Answer

The answer of A non index-organized table is also called...

Question 15

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

Accepted Answer

The answer of The index of a relational table is...

Question 16

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.

Accepted Answer

The answer of The DBA_RECYCLEBIN and ____________________ metadata views can...

Question 17

____________________-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.

Accepted Answer

The answer of ____________________-based optimization uses statistics on the actual...

Question 18

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

Accepted Answer

The answer of The high ____________________ is the boundary between...

Question 19

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

Accepted Answer

The answer of A dropped table,saved to the recycle bin,can...

Question 20

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.

Accepted Answer

The answer of Oracle 10g has a feature called _________________________,allowing...

Quiz 8: Advanced Table Management