Answer a explanation if you set a value for the

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
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

Ask a homework question - tutors are online