Question 1

A(n)____________________ is a list of individual blocks within an extent that have room available for inserting new rows.

Accepted Answer

The answer of A(n)____________________ is a list of individual blocks...

Question 2

____________________ segments are used to store data for objects,such as tables,object tables,and triggers.

Accepted Answer

The answer of ____________________ segments are used to store data...

Question 3

When creating a locally managed,temporary tablespace,the word TEMPORARY goes ____________________ the tablespace name.

Accepted Answer

The answer of When creating a locally managed,temporary tablespace,the word...

Question 4

Segment space management applies only to ____________________ managed tablespaces.

Accepted Answer

The answer of Segment space management applies only to ____________________...

Question 5

After you have loaded data into tables,if that data never changes (or rarely changes),such as a table of the states in the United States,you might consider storing all this static data in a(n)____________________ tablespace.

Accepted Answer

The answer of After you have loaded data into tables,if...

Question 6

When you modify the DEFAULT ____________________ clause from its original settings using the ALTER TABLESPACE command,the new settings only affect blocks created after the change.

Accepted Answer

The answer of When you modify the DEFAULT ____________________ clause...

Question 7

You can drop an undo tablespace by using the ____________________ TABLESPACE command.

Accepted Answer

The answer of You can drop an undo tablespace by...

Question 8

____________________ segments are used to store all the index data.

Accepted Answer

The answer of ____________________ segments are used to store all...

Question 9

____________________ managed tablespaces reduce and even eliminate the problem of unused gaps of free space by ensuring that all the extents allocated to any object within the tablespace are of the same or multiples of that size.

Accepted Answer

The answer of ____________________ managed tablespaces reduce and even eliminate...

Question 10

An undo tablespace is an entire tablespace reserved for ____________________ data.

Accepted Answer

The answer of An undo tablespace is an entire tablespace...

Question 11

When the database was created,if the ____________________ tablespace was created as a locally managed tablespace,no dictionary-managed tablespaces are allowed in the database.

Accepted Answer

The answer of When the database was created,if the ____________________...

Question 12

Primary and foreign keys are both ____________________ (enforced restrictions)on rows in tables.

Accepted Answer

The answer of Primary and foreign keys are both ____________________...

Question 13

A(n)____________________ is the set of extents that make up one schema object within a tablespace.

Accepted Answer

The answer of A(n)____________________ is the set of extents that...

Question 14

If a tablespace has ____________________ status,the tablespace is not available to users even though the database is open.

Accepted Answer

The answer of If a tablespace has ____________________ status,the tablespace...

Question 15

When more space is needed for an object,such as a table,the space is allocated in the form of one ____________________.

Accepted Answer

The answer of When more space is needed for an...

Question 16

Diagnostic files,or ____________________ files,allow highly detailed resolution of problems.

Accepted Answer

The answer of Diagnostic files,or ____________________ files,allow highly detailed resolution...

Question 17

Oracle recommends creating all new tablespaces with ____________________ management.

Accepted Answer

The answer of Oracle recommends creating all new tablespaces with...

Question 18

The IMMEDIATE,TEMPORARY,and ____________________ options do not apply to taking a datafile offline.

Accepted Answer

The answer of The IMMEDIATE,TEMPORARY,and ____________________ options do not apply...

Question 19

You could think of each ____________________ block as containing the before image of the data in the block.

Accepted Answer

The answer of You could think of each ____________________ block...

Question 20

Multiple temporary tablespaces require a tablespace ____________________.

Accepted Answer

The answer of Multiple temporary tablespaces require a tablespace ____________________....

Quiz 5: Basic Storage Concepts and Settings