Answer a explanation if you set a value for the

This is the end of the preview. Sign up
to
access the rest of the document.

Unformatted text preview: s.
Answer: A
Explanation:
If you set a value for the FAST_START_MTTR_TARGET too low DBWR will write the
data blocks more frequently to reduce recovery time in accordance with the
FAST_START_MTTR_TARGET parameter. It can cause the overall database
performance degradation.
Incorrect Answers
B: It will not make LGWR to write redo blocks more frequently: data blocks will be
written more frequently by DBWR.
C: You don't need to substantially increase the size of your database buffer cache to hold
the additional checkpoint records.
D: You don't need to substantially increase the size of your redo buffer cache to hold the
additional checkpoint records.
OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 42-45
Chapter 2: Availability Enhancements
Oracle 9i New Features, Robert Freeman, p. 73-75
Chapter 3: New Oracle9i Availability and Recoverability Features
QUESTION 21:
The CURSOR_SHARING parameter is set to SIMILAR at the instance level and
you issue these SELECT statements in the order shown below:
SELECT * FROM employees WHERE department _id=50;
SELECT * FROM employees WHERE department_id=70;
There is an index on the DEPARTMENT ID column of the 1,000,000 row
EMPLOYEES table. Ninety percent of the employees are part of
DEPARTMENT_ID 50.
In which two scenarios will Oracle9i share the corresponding cursors for the two
statements? (Choose two.)
A. You are using the rule-based optimizer.
B. You are using the cost-based optimizer with up-to-date statistics but with no
histograms.
Actualtests.com - The Power of Knowing 1Z0-030
C. You are using the cost-based optimizer with up-to-date statistics and histograms
computed for the DEPARTMENT_ID column.
D. You are using the cost-based optimizer with up-to-date statistics and histograms
computed for the DEPARTMENT_ID column and system statistics gathered.
Answer: A, B
Explanation:
Oracle9i will share the corresponding cursors for the two statements if you are using the
rule-based optimizer or the cost-based optimizer with up-to-date statistics but with no
histograms.
Incorrect Answers
C: Oracle9i will not share the corresponding cursors if you are using the cost-based
optimizer with up-to-date statistics and histograms computed for the
DEPARTMENT_ID column.
D: The corresponded cursors will not be shared by Oracle if you use the cost-based
optimizer with up-to-date statistics and histograms computed for the
DEPARTMENT_ID column and system statistics gathered.
OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 215-217
Chapter 4: Performance and Scalability Enhancements
Oracle 9i New Features, Robert Freeman, p. 57-59
Chapter 2: Oracle9i Architecture Changes
QUESTION 22:
To increase the availability of an Advanced Replication environment, you can add a
new master to a replication group without quiescing the group. This is achieved
____________.
A. Only when the new master site already has existing replication groups
B. By issuing a single command to create, populate, and activate the new master
C...
View Full
Document