Question 1

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

Accepted Answer

The answer of Other than the huge impact of parallel...

Question 2

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

Accepted Answer

The answer of An Oracle database,as a whole,is made up...

Question 3

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

Accepted Answer

The answer of Oracle ____________________ allows scheduling of batch jobs...

Question 4

The ____________________ tablespace contains Oracle database metadata structures.

Accepted Answer

The answer of The ____________________ tablespace contains Oracle database metadata...

Question 5

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

Accepted Answer

The answer of ____________________ are logical overlays of underlying datafiles,allowing...

Question 6

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

Accepted Answer

The answer of The ____________________ control file view contains names...

Question 7

The MAXLOGHISTORY phrase applies only to Oracle Real _________________________.

Accepted Answer

The answer of The MAXLOGHISTORY phrase applies only to Oracle...

Question 8

RAC stands for _________________________.

Accepted Answer

The answer of RAC stands for _________________________....

Question 9

____________________ occur during database shutdown,during a redo log switch (occurs when one redo log file is filled,and the next in the sequence is switched to),and when one is forced by an ALTER SYSTEM CHECKPOINT command.

Accepted Answer

The answer of ____________________ occur during database shutdown,during a redo...

Question 10

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

Accepted Answer

The answer of A(n)____________________ of computers is made up of...

Question 11

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

Accepted Answer

The answer of The ____________________ Control is the Oracle Enterprise...

Question 12

DML stands for ______________________________.

Accepted Answer

The answer of DML stands for ______________________________....

Question 13

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

Accepted Answer

The answer of Partitioning can increase performance drastically in very...

Question 14

ASM stands for ______________________________.

Accepted Answer

The answer of ASM stands for ______________________________....

Question 15

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

Accepted Answer

The answer of Undo or ____________________ data can be used...

Question 16

DDL stands for _________________________.

Accepted Answer

The answer of DDL stands for _________________________....

Question 17

SCN stands for _________________________.

Accepted Answer

The answer of SCN stands for _________________________....

Question 18

____________________ contain all the data in an Oracle database.

Accepted Answer

The answer of ____________________ contain all the data in an...

Question 19

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

Accepted Answer

The answer of One of the most significant problems with...

Question 20

SGA stands for ____________________.

Accepted Answer

The answer of SGA stands for ____________________....

Quiz 4: Oracle Physical Architecture and Data Dictionary Views