Com the power of knowing 1z0 024 more shared servers

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: ameters file that can cause problems when starting Actualtests.com - The Power of Knowing 1Z0-024 more shared servers: PROCESSES and MTS_MAX_SERVERS. Incorrect Answers: C: There is no MTS_MAX_PROCESSES parameter in Oracle. D: The MTS_MAX_DISPATCHER parameter will not cause any problems when staring more shared servers. E: The PARALLEL_MAX_SEVERS parameter is not related directly with shared servers to cause problems. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 858-859. Chapter 18: Tuning Memory and Operating System Use QUESTION 85: When does Oracle allocate memory for the large pool during instance startup? A. When the PARALLEL_AUTOMATIC_TUNNING is set to FALSE B. When oracle is configured to use the Multihreaded Server. C. When the LARGE_POOL_SIZE parameter is set to a valid value. D. When the large pool has a default value and is automatically allocated on instance startup. Answer: C Explanation: When the LARGE_POOL_SIZE parameter is set to a valid value Oracle allocates memory for the large pool during instance startup. If value is wrong, large pool will not be allocated. Incorrect Answers: A: There is no correlation with PARALLEL_AUTOMATIC_TUNNING parameter and large pool. This parameter enables intelligent defaults for parallel execution parameters. B: Large pool can be used with the Dedicated Server mode also, not only with the Multihreaded Server. D: The large pool is optional structure of memory and does not have a default value. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 857-858. Chapter 18: Tuning Memory and Operating System Use QUESTION 86: Which procedure of the DBMS_RESOURCE_MANAGER package would first need to be performed when creating a new resource object? A. CREATE_PLAN B. CREATE_PENDING_AREA C. CREATE_CONSUMER_GROUP D. CREATE_PLAN_DIRECTIVE Answer: B Explanation: Actualtests.com - The Power of Knowing 1Z0-024 The DBMS_RESOURCE_MANAGER package would first need CREATE_PENDING_AREA procedure to be performed when creating a new resource object. Incorrect Answers: A: CREATE_PLA...
View Full Document

Ask a homework question - tutors are online