Question 1

In theory,multiple snapshots can be compared to allow for search and analysis of problems.

Accepted Answer

A) True 
 B)False

Question 2

The ____advisor warns and alerts with respect to potential instance recovery,potential media recovery,and potential flashback recovery.

Accepted Answer

A)  Memory 
B)  Undo Management and Undo 
C)  ADDM 
D)  Segment 
A)  Memory 
B)  Undo Management and Undo 
C)  ADDM 
D)  Segment

Question 3

Read consistency is very important to a relational database.

Accepted Answer

A) True 
 B)False

Question 4

Running out of disk space can crash a database because it has no space to write changes to disk.

Accepted Answer

A) True 
 B)False

Question 5

SGA stands for ____________________.

Accepted Answer

The answer of SGA stands for ____________________....

Question 6

The ______________________________ contains memory required for concurrent connections.

Accepted Answer

PGA
Progra

Question 7

The ____________________ advisor is similar to the SQL access advisor,but will analyze SQL code,perhaps making recommendations for improving performance.

Accepted Answer

The answer of The ____________________ advisor is similar to the...

Question 8

With respect to the proactive maintenance default configuration,for most databases it is very likely that you will need to change the default setup in the Database Control.

Accepted Answer

A) True 
 B)False

Question 9

PGA memory has been automatically managed since Oracle 8.

Accepted Answer

A) True 
 B)False

Question 10

Automated undo has removed the need for complex maintenance of manual ____________________ segments.

Accepted Answer

The answer of Automated undo has removed the need for...

Question 11

The Java pool can be set to ____________________ if Java is not in use.

Accepted Answer

The answer of The Java pool can be set to...

Question 12

The ____advisor searches for,automatically detects,and posts warnings and alerts for segment issues.

Accepted Answer

A)  Memory 
B)  Undo Management and Undo 
C)  ADDM 
D)  Segment 
A)  Memory 
B)  Undo Management and Undo 
C)  ADDM 
D)  Segment

Question 13

The primary focus of the ____________________ advisor is forecasting.

Accepted Answer

The answer of The primary focus of the ____________________ advisor...

Question 14

A(n)____________________ is like a pipe in that it allows sharing of information between multiple databases by way of messages.

Accepted Answer

The answer of A(n)____________________ is like a pipe in that...

Question 15

The ____advisor advises as to the optimal configuration of automated undo.

Accepted Answer

A)  Memory 
B)  Undo Management and Undo 
C)  ADDM 
D)  Segment 
A)  Memory 
B)  Undo Management and Undo 
C)  ADDM 
D)  Segment

Question 16

The objective of setting a PGA max size is to inhibit run-away operations.

Accepted Answer

A) True 
 B)False

Question 17

Proactive maintenance is contrary to ____________________ maintenance.

Accepted Answer

The answer of Proactive maintenance is contrary to ____________________ maintenance....

Question 18

A baseline alert critical level (based on significance)of ____ corresponds to an Extreme level.

Accepted Answer

A)  .9 
B)  .99 
C)  .999 
D)  .9999 
A)  .9 
B)  .99 
C)  .999 
D)  .9999

Question 19

The ____________________ is memory space allocated for database-driven Java code.

Accepted Answer

The answer of The ____________________ is memory space allocated for...

Question 20

MTTR stands for _________________________.

Accepted Answer

Mean Time

In theory,multiple snapshots can be compared to allow for search and analysis of problems.

The ____advisor warns and alerts with respect to potential instance recovery,potential media recovery,and potential flashback recovery.

Read consistency is very important to a relational database.

Running out of disk space can crash a database because it has no space to write changes to disk.

SGA stands for ____________________.

The ______________________________ contains memory required for concurrent connections.

The ____________________ advisor is similar to the SQL access advisor,but will analyze SQL code,perhaps making recommendations for improving performance.

With respect to the proactive maintenance default configuration,for most databases it is very likely that you will need to change the default setup in the Database Control.

PGA memory has been automatically managed since Oracle 8.

Automated undo has removed the need for complex maintenance of manual ____________________ segments.

The Java pool can be set to ____________________ if Java is not in use.

The ____advisor searches for,automatically detects,and posts warnings and alerts for segment issues.

The primary focus of the ____________________ advisor is forecasting.

A(n)____________________ is like a pipe in that it allows sharing of information between multiple databases by way of messages.

The ____advisor advises as to the optimal configuration of automated undo.

The objective of setting a PGA max size is to inhibit run-away operations.

Proactive maintenance is contrary to ____________________ maintenance.

A baseline alert critical level (based on significance)of ____ corresponds to an Extreme level.

The ____________________ is memory space allocated for database-driven Java code.

MTTR stands for _________________________.

Oracle Architecture Overview

Tools and Architecture

Creating an Oracle Instance

Oracle Physical Architecture and Data Dictionary Views

Basic Storage Concepts and Settings

The Basics of Querying a Database

Basic Table Management

Advanced Table Management

Constraints, indexes, and Other Specialized Objects

Basic Data Management

Advanced Data Management

Security Management

Performance Monitoring

Backup and Recovery

Filters

Exam 14: Proactive Maintenance

In theory,multiple snapshots can be compared to allow for search and analysis of problems.

The ____advisor warns and alerts with respect to potential instance recovery,potential media recovery,and potential flashback recovery.

Read consistency is very important to a relational database.

Running out of disk space can crash a database because it has no space to write changes to disk.

SGA stands for ____________________.

The ______________________________ contains memory required for concurrent connections.

The ____________________ advisor is similar to the SQL access advisor,but will analyze SQL code,perhaps making recommendations for improving performance.

With respect to the proactive maintenance default configuration,for most databases it is very likely that you will need to change the default setup in the Database Control.

PGA memory has been automatically managed since Oracle 8.

Automated undo has removed the need for complex maintenance of manual ____________________ segments.

The Java pool can be set to ____________________ if Java is not in use.

The ____advisor searches for,automatically detects,and posts warnings and alerts for segment issues.

The primary focus of the ____________________ advisor is forecasting.

A(n)____________________ is like a pipe in that it allows sharing of information between multiple databases by way of messages.

The ____advisor advises as to the optimal configuration of automated undo.

The objective of setting a PGA max size is to inhibit run-away operations.

Proactive maintenance is contrary to ____________________ maintenance.

A baseline alert critical level (based on significance)of ____ corresponds to an Extreme level.

The ____________________ is memory space allocated for database-driven Java code.

MTTR stands for _________________________.

Oracle Architecture Overview

Tools and Architecture

Creating an Oracle Instance

Oracle Physical Architecture and Data Dictionary Views

Basic Storage Concepts and Settings

The Basics of Querying a Database

Basic Table Management

Advanced Table Management

Constraints, indexes, and Other Specialized Objects

Basic Data Management

Advanced Data Management

Security Management

Performance Monitoring

Backup and Recovery

Filters