Exam 5: Basic Storage Concepts and Settings

What are rollback segments?

The size of an operating system block is 8 bytes.

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

The storage capacity of a tablespace is the sum of the size of all the datafiles assigned to that tablespace.

____________________ structures are composed of orderly groupings of information that allow you to manipulate and access related data.

The utility ____ reads trace files and loads the data into a readable file or even loads it into a database table so you can query the results.

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

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

A(n)____ is the largest logical object.

The contents of the datafiles are stored in encrypted and specialized record structures readable only by the Oracle 10g database.

If your tablespace keeps running out of space,you may want to modify the ____ setting.

A ____ is a physical file on the computer.

A database may not contain a large number of tablespaces.

What is a schema object?

The ____ view contains information on free extents within all tablespaces.

You may only perform one task per ALTER TABLESPACE command.

The freelist is the same as the free space in a datafile.

To modify a tempfile,you can use the ____ command.

Tablespaces are ____-managed by default.

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