Big frequently d small frequently answer d

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: ly Answer: D Explanation: Answer D is correct. The table should be small and frequently used to allow usage of the CACHE clause. This clause will load table in the cache for quick table data processing in memory without loading data blocks from the disk. Incorrect Answers: A: Big and rarely used table is bad candidate for caching. B: There is no sense to put table in the cache if it is used rarely. C: Big table is bad candidate for caching. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 345-348 Chapter 18: Tuning Memory and Operating System Use QUESTION 94: What are two characteristics of the control file? (Choose two) A. It has a fixed size. B. It should be multiplexed. C. It can be edited by the DBA D. It is required to start the instance E. It is required to open the database F. It is associated with multiple databases Answer: B, E Explanation: Answers B and E are correct. The control file should be multiplexed to reduce Oracle's dependence on any one disk available on the host machine. In the event of failure, the datab...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online