D same tablespace as the employee table answer b

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: efault tablespace. C. Tablespace will rollback segments. D. Same tablespace as the EMPLOYEE table. Answer: B Explanation: Index EMP_INDX will be created in Scott's default tablespace by default in Oracle8i. Incorrect Answers: A: It's only possible if Scott has SYSTEM tablespace as default tablespace, but question does not mention about this fact. C: Index will be created in Scott's default tablespace, not in RBS tablespace. D: Index will be created in Scott's default tablespace, not in the same tablespace as the EMPLOYEE table uses. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 917-918. Chapter 19: Tuning Disk utilization Actualtests.com - The Power of Knowing 1Z0-024 QUESTION 81: When setting multiple LRU latches in your initialization parameter file, what might you also consider setting? A. One buffer pool for each latch. B. One DBWn process for each latch. C. At one shared server for each latch. D. At least two DBWn processes for each latch. Answer: B Explanation: It's reasonable to consider to set one DBWn process for each latch when setting multiple LRU latches in your initialization parameter file. The LRU (least-recently-used) latch controls the server process's access to write new buffers into the buffer cache. Oracle automatically sets the number of LRU latches to be one-half the number of CPUs on the system. When your host machine has only one processor, one LRU latch is sufficient. Contention for the LRU latch can impede database performance when a large number of CPUs are available on the host system, when only one DBW0 process is available on the database, or when the load between multiple DBWn processes is unequally distributed. Incorrect Answers: A: S latch should have no less than 50 buffers in its set. C: There is no direct relation between shared servers and latches in Oracle. D: Each latch requires at least one, not two, DBWn process. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 855-856. Chapter 20: Tuning Other Areas of the Oracle Database QUESTION 82: What can you use the values in the GETS and GETMISSES...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online