Exam 5: Basic Storage Concepts and Settings

Each ____ belongs to one schema object.

When you take a tablespace offline,there are ____ methods you can specify for Oracle 10g's execution of the command.

Undo tablespaces are specialized to store undo (____)data.

Each index has one index segment.

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

Extents always belong to one datafile.

You can create a tablespace before creating its initial datafile.

The EXTENT MANAGEMENT and ____ MANAGEMENT clauses of the CREATE TABLESPACE command tell Oracle 10g how to track the usage of blocks within each extent.

Segment space management applies only to ____________________ managed tablespaces.

A smallfile tablespace can contain ____ datafiles.

Trace files can be found in both the bdump and ____ directories.

Tables,indexes,and other objects are created within a(n)____________________.

When creating a tablespace,the ____ option allows creation of very large permanent or temporary tablespaces,with a single very large datafile.

After a database is created,you cannot change the block size without re-creating the database.

The extent management mode can be changed using the ALTER TABLESPACE command.

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

The initialization parameter ____ contains the default or standard block size.

A datafile can be made up of several fragmented sections in different locations on the operating system.

An operating system ____________________ is made up of a group of contiguous bytes within the file.

____________________ segments are used to store all the index data.