Exam 4: Oracle Physical Architecture and Data Dictionary Views

The ____ tablespace contains Oracle optional software metadata and data.

A(n)____ background process is a process that copies a completed online redo log file to an archived redo log file.

Renaming a redo log file may be done to keep up with new naming standards or simply to make the filenames more meaningful to you.

____ are the logical layer of an Oracle database.

The REUSE clause of the CREATE CONTROLFILE command is required.

DML stands for ______________________________.

You cannot rename or relocate a control file.

____ partitioning divides partition values evenly based on hash values calculated from a column value or values in each row of a table.

The ____ clause of the CREATE CONTROLFILE command tells Oracle 10g to overwrite any existing control files it finds.

The primary use for the ____________________ performance views is tuning the database system.

There can be up to ____ archiver processes.

____ mode restricts access to a database to administration level only.

The ____________________ control file view contains names and numbers of tablespaces.

An online redo log group (or member of a group)can be dropped only when the group is ____________________.

The ____ tablespace contains all the metadata,or the data about the data,such as the structures of user application tables.

The ____________________ tablespace contains Oracle database metadata structures.

Partitioning can increase performance drastically in very large databases,both for data warehouses and even ______________________________ (OLTP)databases.

____ redo log files means that multiple redo log members,in each redo log group,are written to in parallel.

The ____ control file view contains copies of recycled redo log files.

The log writer process (____)updates the control file records whenever a new log sequence number is started.