Exam 4: Oracle Physical Architecture and Data Dictionary Views

Oracle streams cannot be updated.

The only required initialization parameter to achieve successful ARCHIVELOG mode is the ____ parameter.

The ____ control file view contains online redo log group information.

____ are the physical layer of an Oracle database.

____ partitioning partitions can contain other subset partitions or subpartitions,allowing combinations of visibly split ranges or lists,with evenly spread hash partitioning.

A(n)____ background process is a process that initiates flushing of buffers,causing the LGWR to write data blocks from the redo log buffer to the online redo log file

____ contain pointers to all datafiles and log files used for synchronization between all of those files.

____ displays initialization parameter values,including the current value of the CONTROL_FILES parameter.

The database name is defined either in the CREATE DATABASE command or the ____ initialization parameter.

____ partitioning splits a table based on distinct ranges of values,such as quarters in a year.

Each tablespace can contain multiple datafiles.

A new control file can be added at any time.

A single redo log entry is stamped with a(n)____.

The ____ data dictionary view contains source code for all stored objects,such as functions,Java source,and triggers.

DDL stands for _________________________.

The status of a redo log group can be ____ if it is not needed for crash recovery.

Oracle ____ are much like opening a direct pipeline between different servers and databases.

What is the role of Oracle RAC?

RAC stands for _________________________.

ASM stands for ______________________________.