Question 1

Write consistency implies that if one user makes a change without committing or rolling back,then only the user who made the change can see that change.

Accepted Answer

A) True 
 B)False  False

Question 2

If the database buffer cache is too big it could be attempting to share data that is not frequently used.

Accepted Answer

A) True 
 B)False  True

Question 3

With respect to proactive maintenance tasks managed within the Database Control,there is a default configuration within the advisors and metrics provided when you create a database.

Accepted Answer

A) True 
 B)False  True

Question 4

____ is NOT an advisor available within the Advisor Central of the Database Control.

Accepted Answer

A)  ADDM 
B)  Undo Management 
C)  MTTR Advisor 
D)  AWR 
A)  ADDM 
B)  Undo Management 
C)  MTTR Advisor 
D)  AWR

Question 5

For a data warehouse the database buffer cache should be as large as possible.

Accepted Answer

A) True 
 B)False

Question 6

____ is not a port commonly used by the Database Control.

Accepted Answer

A)  1158 
B)  3367 
C)  5500 
D)  5600 
A)  1158 
B)  3367 
C)  5500 
D)  5600

Question 7

Setting the SGA ____________________ configuration parameter to a value greater than zero enables automated SGA memory management.

Accepted Answer

The answer of Setting the SGA ____________________ configuration parameter to...

Question 8

32 Mb for a database buffer cache is a little too small.

Accepted Answer

A) True 
 B)False

Question 9

The Database Control will not allow the Java pool buffer size to be set to 0.

Accepted Answer

A) True 
 B)False

Question 10

____________________ undo allows rollback of transactions,recovery of aborted and partly completed transactions,and some recovery.

Accepted Answer

The answer of ____________________ undo allows rollback of transactions,recovery of...

Question 11

The SGA ____ contains application data.

Accepted Answer

A)  shared pool 
B)  database buffer cache 
C)  large pool 
D)  streams pool 
A)  shared pool 
B)  database buffer cache 
C)  large pool 
D)  streams pool

Question 12

The ____________________ the undo tablespace,the larger the physical size of changes that can be undone.

Accepted Answer

The answer of The ____________________ the undo tablespace,the larger the...

Question 13

Few database engines function by making changes physically in the database as soon as the change is made (regardless of the execution of a COMMIT or ROLLBACK command).

Accepted Answer

A) True 
 B)False

Question 14

To execute the Database Control there needs to be a background process (a ____ on a Windows computer)running on the database server that executes the Database Control over the network.

Accepted Answer

A)  daemon 
B)  server 
C)  service 
D)  thread 
A)  daemon 
B)  server 
C)  service 
D)  thread

Question 15

A(n)____________________ is a picture of a database at a specific point in time.

Accepted Answer

The answer of A(n)____________________ is a picture of a database...

Question 16

The ____________________ of a relational database contains all system metadata and application tables,indexes,materialized views,and so on.

Accepted Answer

The answer of The ____________________ of a relational database contains...

Question 17

Describe the sections of the segment advisor.

Accepted Answer

The segment advisor consists of a number

Question 18

Preserved snapshots are used in the same manner as snapshots,in that they can be used for comparison against other snapshots.

Accepted Answer

A) True 
 B)False

Question 19

The undo advisor will help you with the settings for automated undo configuration parameters,including retention and tablespace sizing.

Accepted Answer

A) True 
 B)False

Question 20

A baseline alert warning level (based on significance)of ____ corresponds to a Severe level.

Accepted Answer

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

Write consistency implies that if one user makes a change without committing or rolling back,then only the user who made the change can see that change.

If the database buffer cache is too big it could be attempting to share data that is not frequently used.

With respect to proactive maintenance tasks managed within the Database Control,there is a default configuration within the advisors and metrics provided when you create a database.

____ is NOT an advisor available within the Advisor Central of the Database Control.

For a data warehouse the database buffer cache should be as large as possible.

____ is not a port commonly used by the Database Control.

Setting the SGA ____________________ configuration parameter to a value greater than zero enables automated SGA memory management.

32 Mb for a database buffer cache is a little too small.

The Database Control will not allow the Java pool buffer size to be set to 0.

____________________ undo allows rollback of transactions,recovery of aborted and partly completed transactions,and some recovery.

The SGA ____ contains application data.

The ____________________ the undo tablespace,the larger the physical size of changes that can be undone.

Few database engines function by making changes physically in the database as soon as the change is made (regardless of the execution of a COMMIT or ROLLBACK command).

To execute the Database Control there needs to be a background process (a ____ on a Windows computer)running on the database server that executes the Database Control over the network.

A(n)____________________ is a picture of a database at a specific point in time.

The ____________________ of a relational database contains all system metadata and application tables,indexes,materialized views,and so on.

Describe the sections of the segment advisor.

Preserved snapshots are used in the same manner as snapshots,in that they can be used for comparison against other snapshots.

The undo advisor will help you with the settings for automated undo configuration parameters,including retention and tablespace sizing.

A baseline alert warning level (based on significance)of ____ corresponds to a Severe level.

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

Write consistency implies that if one user makes a change without committing or rolling back,then only the user who made the change can see that change.

If the database buffer cache is too big it could be attempting to share data that is not frequently used.

With respect to proactive maintenance tasks managed within the Database Control,there is a default configuration within the advisors and metrics provided when you create a database.

____ is NOT an advisor available within the Advisor Central of the Database Control.

For a data warehouse the database buffer cache should be as large as possible.

____ is not a port commonly used by the Database Control.

Setting the SGA ____________________ configuration parameter to a value greater than zero enables automated SGA memory management.

32 Mb for a database buffer cache is a little too small.

The Database Control will not allow the Java pool buffer size to be set to 0.

____________________ undo allows rollback of transactions,recovery of aborted and partly completed transactions,and some recovery.

The SGA ____ contains application data.

The ____________________ the undo tablespace,the larger the physical size of changes that can be undone.

Few database engines function by making changes physically in the database as soon as the change is made (regardless of the execution of a COMMIT or ROLLBACK command).

To execute the Database Control there needs to be a background process (a ____ on a Windows computer)running on the database server that executes the Database Control over the network.

A(n)____________________ is a picture of a database at a specific point in time.

The ____________________ of a relational database contains all system metadata and application tables,indexes,materialized views,and so on.

Describe the sections of the segment advisor.

Preserved snapshots are used in the same manner as snapshots,in that they can be used for comparison against other snapshots.

The undo advisor will help you with the settings for automated undo configuration parameters,including retention and tablespace sizing.

A baseline alert warning level (based on significance)of ____ corresponds to a Severe level.

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