Question 1

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

Accepted Answer

A)   Data
B)   Rollback
C)   Index
D)   Temporary B

Question 2

Undo data is made up of ____ blocks.

Accepted Answer

A)   file
B)   contiguous
C)   data
D)   undo D

Question 3

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

Accepted Answer

freelist

Question 4

____ is the default status for a new tablespace.

Accepted Answer

A)   TEMPORARY
B)   IMMEDIATE
C)   ONLINE
D)   OFFLINE

Question 5

What is the difference between temporary and permanent tablespaces?

Accepted Answer

The answer of What is the difference between temporary and...

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

A)   LGWR
B)   LDWR
C)   DFWn
D)   DBWn

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

A tablespace is a physical structure.

Accepted Answer

A) True 
 B)False

Question 10

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 11

Index segments are allowed in temporary tablespaces.

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

A)   1KB
B)   2KB
C)   4KB
D)   8KB

Question 14

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

Accepted Answer

A)   tablespace
B)   datafile
C)   database
D)   instance

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

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 19

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

Accepted Answer

A)   NOARCHIVELOG
B)   NOLOGGING
C)   TEMPORARY
D)   IMMEDIATE

Question 20

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

Accepted Answer

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

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.