Exam 5: Basic Storage Concepts and Settings

A ____-managed tablespace stores the details about its free space and other information inside the data dictionary tables,in the SYSTEM tablespace.

The ____ view contains details on default and temporary tablespaces assigned to all users.

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.

The data dictionary views primarily display metadata.

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

Each tablespace contains one or more ____________________.

A ____ is a small record in the datafile header with one bit for each data block number that marks the beginning of a used group,or a free group,of consecutive blocks in the datafile.

Data blocks are made up of one or more operating system blocks,depending on the size of each type of block.

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

Datafiles are the primary physical structure that contain all the data you store in the database.

A data block is typically ____.

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

____ contain the names and locations of all the datafiles and redo log files.

A ____-managed tablespace has a bitmap in the header of the tablespace that stores all the details about free space,used space,and location of extents.

Why would you want to create a special tablespace with its own data block size?

A(n)____ contains a copy of a primary key value from a parent table.

The CREATE TABLESPACE ____ option indicates that the tablespace is allowed to automatically grow.

A(n)____ uniquely identifies each row in a table.

Oracle recommends creating all new tablespaces with ____________________ management.

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