Incorrect answers a the timedstatistics parameter

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: aying there is not enough shared memory in your database. Incorrect Answers: A: The TIMED_STATISTICS parameter does not relate with CURSOR_SPACE_FOR_TIME parameter. B: The hit percentage in the library cache must be 100 %, it is not related with percentage in the buffer cache. C: There is no restriction on OPEN_CURSORS parameter for CURSOR_SPACE_FOR_TIME parameter value setting to TRUE. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 851. Chapter 18: Tuning Memory and Operating System Use QUESTION 79: Data dictionary information is held in memory longer than library cache data. Which is most likely to be true as a consequence of this? A. You do no not need to monitor library cache usage. Actualtests.com - The Power of Knowing 1Z0-024 B. You have to tune the database buffer cache regularly. C. You have to tune the library cache and dictionary cache independently. D. Good hit ratios in the library cache imply acceptable hit ratios in the dictionary cache. E. Good hit ratios in the dictionary cache imply acceptable hit ratios on the database buffer cache. Answer: D Explanation: Good hit ratios in the library cache imply acceptable hit ratios in the dictionary cache if data dictionary information is held in memory longer than library cache data. Incorrect Answers: A: You need to monitor library cache usage any way to improve its performance. B: There is no direct relation between time of data dictionary information holding and database buffer tuning. C: The library cache and dictionary cache are related very closely, so it's impossible to tune them independently. E: The dictionary cache will not imply acceptable hit ratios on the database buffer cache: they do not correlate directly. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 849-855. Chapter 18: Tuning Memory and Operating System Use QUESTION 80: User SCOTT creates an index with this statement; CREATE INDEX emp_index on employee (empno); In which tablespace would the index be created? A. SYSTEM tablespace. B. Scott's d...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online