B recursive sql are stored in the library cache not

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 not the same as the data dictionary cache. B: Recursive SQL are stored in the library cache, not in the data dictionary cache. D: An object can be pinned in the shared pool with the DBMS_SHARED_POOL. It does not matter whether this object have been in the shared pool or not. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 852-854. Chapter 18: Tuning Memory and Operating System Use QUESTION 72: Which action could result in less frequent checkpoints? A. Increasing the number of redo log groups. B. Increasing the value of DB_BLOCK_SIZE parameter. C. Decreasing the value of the REDO_LOG_BUFFERS parameter. D. Increasing the value of the FAST_START_IO_TARGET parameter. Actualtests.com - The Power of Knowing 1Z0-024 Answer: D Explanation: The frequency of checkpoints will be decreased if the value of the FAST_START_IO_TARGET will be increased: Oracle will need more time to recover database after instance crash. Incorrect Answers: A: The number of redo log groups has no relation with frequency of checkpoints. B: DB_BLOCK_SIZE buffer has nothing to do with checkpoints. D: By decreasing the value of the REDO_LOG_BUFFERS you will INCREASE frequency of checkpoints because redo log files will be filled with updates more quickly. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 902. Chapter 19: Tuning Database Utilization QUESTION 73: Which two statements about database blocks are true? (Choose two) A. OLTP environments prefer a large block size B. Small block size results in more block contention C. Sequential access to large amounts of data favors a large block size D. You can reduce the number of block visits by packaging rows as closely as possible into blocks. E. To change the database block size, you must shut down the instance and perform a STARTUP RESETLOGS after you make the change. Answer: C, D Explanation: The key feature of a decision support system is fast sequential access to large amounts of data, so DSS environment prefer a large database block size. Also remember that you can reduce the number of block visits by packing rows as closely as possible into blocks, so Oracle will need less...
View Full Document

{[ snackBarMessage ]}

Ask a homework question - tutors are online