Exam 5: Basic Storage Concepts and Settings

____ segments are allowed in undo tablespaces (if automatic undo management)or any permanent tablespace (if manual undo management).

Undo data is made up of ____ blocks.

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

____ is the default status for a new tablespace.

What is the difference between temporary and permanent tablespaces?

There is a direct correlation between a segment and a datafile.

Changes to data are written to datafiles by the ____ background process.

All critical errors need to be sent to the trace files.

A tablespace is a physical structure.

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

Index segments are allowed in temporary tablespaces.

Logical structures can be viewed or modified outside the database (from the operating system).

A data block can't be smaller than ____ or larger than 32KB.

The ____ is made up of database files,control files,and redo log files.

In an Oracle database,logical structures are generally associated with one or more physical structures.

The biggest issue with using locally managed tablespaces is one of performance.

Dropping a temporary tablespace is the same as dropping a permanent tablespace.

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.

The DROP option is required if you take a datafile offline when your database is in ____ mode.

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