Exam 4: Oracle Physical Architecture and Data Dictionary Views

Describe the role of database replication,including the types of database replication that exist.

The datafiles on a tablespace must be stored on the same disk drive.

If the control file is damaged,the database is damaged too.

A database in ____ mode automatically archives redo log files.

All the data dictionary views except those starting with the ____ prefix have public synonyms and public permission to query.

There are ____ dynamic performance views that display the high-level contents of the control file.

The SYSAUX tablespace was added in Oracle 9.

SGA stands for ____________________.

____ simplifies maintenance of storage space and optimizes for I / O performance.

The ____ control file view contains redo log file information.

A(n)____________________ of computers is made up of a large number of cheaply purchased,simplistic servers.

Sometimes,you may need to manually trigger a log switch.

Datafiles are the physical files stored in the underlying operating system.

The initialization parameter DB_CREATE_ONLINE_LOG_DEST_n is required to be set for the database to function properly.

What is the purpose of grid computing? How can this be achieved?

Oracle-managed log groups may be added to OMF databases by using the following command: ____.

Undo or ____________________ data can be used to undo non-committed changes in a database.

A LGWR background process is a process that writes data blocks from the redo log buffer to the online redo log file.

Oracle Replication has a level of complexity suited to failover and backup management.

____ are lists of information by categories within the control file.