Exam 4: Oracle Physical Architecture and Data Dictionary Views

____________________ contain all the data in an Oracle database.

You can fix a control file by replacing the faulty or missing control file with a valid copy of the control file.

DBA prefixed views are solely for database administration use,allowing access to everything in the database,regardless of who owns it.

The status of a redo log group can be ____ if it is needed for crash recovery,but not currently in use by LGWR.

Oracle ____________________ allows scheduling of batch jobs to be executed repeatedly at specified times.

You can use the SQL*Plus DESCRIBE command (abbreviated to ____)to retrieve a list of column names and data types for any table or view,including the data dictionary views.

____________________ are logical overlays of underlying datafiles,allowing access to data stored in datafiles.

____ allows automated creation and dropping of underlying datafiles,in addition to automated management of both redo log files and control files.

____ lists current checkpoint numbers and control file sequence numbers.

When you type the ____ command,the redo log buffer's redo records are moved to the redo log files.

An Oracle database,as a whole,is made up of a number of integrated parts,otherwise known as the Oracle ____________________ and the Oracle database.

A standby database is a database clone of the current database.

____ a redo log group ensures that you can perform a complete,up-to-the-minute recovery of your database in the event of catastrophic failure,such as the loss of a disk drive that held your SYSTEM tablespace.

One of the most significant problems with the Oracle ____________________ option is that it is often used inappropriately for backup and failover databases.

SCN stands for _________________________.

A(n)____________________,also called a redo entry,is made up of a related group of change vectors that record a description of the changes to a single block in the database.

The ____________________ Control is the Oracle Enterprise Manager equivalent of the Database Control,but for a grid computing architecture.

Other than the huge impact of parallel processing of multiple partitions concurrently,or eliminating unwanted partitions (partitioning ____________________),various tricks can be performed with partitioning.

A public ____________________ is a unique name for an object that allows any user to use the object without prefixing it with the owner name.

A(n)____ log file group has files in the group that cannot be dropped.