Deck 14: Proactive Maintenance

Question 1

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

Answer 1

True

Question 2

The shared pool is the most highly concurrent section of memory for an Oracle database.

Answer 2

True

Question 3

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

Answer 3

True

Question 4

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.

Question 5

The schema advisor tells you about disk space,how it is used,how it should not be used,and what you might want to alter to help everything run smoothly.

Question 6

Much of proactive activity is related to performance tuning a database in one way or another.

Question 7

SGA manages memory operations on a database server,such as sorting,creating bitmaps,and creating hash tables.

Question 8

An increase in shared pool size may harm performance.

Question 9

In most database engines,the execution of a COMMIT or ROLLBACK command simply removes the potential for rollback.

Question 10

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).

Question 11

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

Question 12

Proactive maintenance is all about forecasting and perhaps preventing running out of disk space before it happens.

Question 13

The PGA is controlled by the PGA_AGGREGATE_TARGET parameter;setting this parameter to TRUE enables automated PGA memory management.

Question 14

The advice performance tools (Advice Central section within the Database Control)are new in Oracle 10g.

Question 15

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.

Question 16

Read consistency is very important to a relational database.

Question 17

An increase in database buffer cache size might help performance a little.

Question 18

The streams pool is usually the most critical buffer for any Oracle database.

Question 19

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

Question 20

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.

Question 21

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

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

Question 22

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) daemon
B) server
C) service
D) thread

Question 23

Typically snapshots are created when the database is operating normally.

Question 24

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

Question 25

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

Question 26

Proactive maintenance can be managed from within ____.

A) SQL*Plus
B) SQL*Plus Worksheet
C) Enterprise Manager console
D) the Database Control

Question 27

Changing baseline metrics involves altering the threshold values.

Question 28

The ____advisor performs automated SQL tuning activities.

A) MTTR
B) SQL Tuning
C) SQL Access
D) ADDM

Question 29

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

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

Question 30

Automated SGA memory management was introduced in Oracle9i.

Question 31

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

Question 32

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

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

Question 33

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

Question 34

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

A) Schema Advisor
B) Segment Advisor
C) Memory Advisor
D) SQL Access Advisor

Question 35

PGA memory has been automatically managed since Oracle 8.

Question 36

The ____advisor performs automated diagnostics,by comparing multiple statistical snapshots taken against the database.

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

Question 37

Setting the Java pool to zero if Java is in use is a waste of memory resources.

Question 38

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

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

Question 39

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

Question 40

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

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

Question 41

If you want to make sure that you always retain changes for possible undo,you should set undo retention to the ____.

A) minimum
B) maximum
C) average
D) baseline

Question 42

The SGA ____ contains application data.

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

Question 43

AWR stands for ______________________________.

Question 44

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

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

Question 45

The SGA ____ contains the dictionary cache and the library cache.

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

Question 46

The ____advisor is generally used for materialized view analysis and usually in data warehouses.

A) MTTR
B) SQL Tuning
C) SQL Access
D) ADDM

Question 47

The ____ is made up of various buffers including the shared pool and the database buffer cache.

A) GSA
B) SGA
C) PGA
D) GPA

Question 48

Undo space allows for ____ consistency.

A) read
B) write
C) read / write
D) execute

Question 49

A ____ baseline moves with the current date setting for your database server,from today backwards in time,for whatever period is specified.

A) roll window
B) moving window
C) dynamic window
D) static window

Question 50

In a ____ baseline you select a specific period.

A) preset window
B) moving window
C) fixed window
D) static window

Question 51

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

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

Question 52

Proactive maintenance is contrary to ____________________ maintenance.

Question 53

The objective of proactive maintenance is to prevent critical problems ____________________ they occur and damage a database.

Question 54

When an SQL Access Advisor job that has been scheduled has completed executing,an status of ____ is indicated in the Database Control.

A) COMPLETED
B) FINISHED
C) DONE
D) ENDED

Question 55

The available scope options for the segment advisor are Tablespaces and ____.

A) Tables
B) Indexes
C) Materialized View
D) Schema objects

Question 56

_________________________ is really all about setting up the Database Control to predict and track performance problems.

Question 57

The ______________________________ advisor advises on the usage and sizing of the different memory buffers,including the entire SGA,and session connection memory-PGA.

Question 58

The SGA ____ is used for odd tasks like backups and parallel processing.

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

Question 59

____ is the session connection memory that is shared by connections to the database server.

A) GSA
B) SGA
C) PGA
D) GPA

Question 60

The SGA ____ provides for processing that requires occasional large chunks of memory.

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

Question 61

The ____________________ of a relational database is all the preparsed SQL and PL / SQL code,which is reused when re-executed,within a reasonable period.

Question 62

You can click the Help link at the ____________________ corner of the Database Control page,and read about the contents of the current page.

Question 63

MTTR stands for _________________________.

Question 64

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

Question 65

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

Question 66

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

Question 67

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

Question 68

A(n)____________________ metric is an established,expected,or even hoped for value.

Question 69

A(n)____________________ is essentially a measure of a rate of change.

Question 70

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

Question 71

The undo advisor works best with ____________________ undo.

Question 72

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

Question 73

The ______________________________ contains memory required for concurrent connections.

Question 74

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

Question 75

SGA stands for ____________________.

Question 76

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

Question 77

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

Question 78

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

Question 79

PGA stands for ____________________.

Question 80

The primary focus of the ____________________ advisor is forecasting.