This preview shows page 1. Sign up to view the full content.
Unformatted text preview: ly
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.
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
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
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.
- Fall '09