Incorrect answers b oracle parallel query can use

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: from the large pool. Incorrect Answers: B: Oracle Parallel Query can use memory from the large pool. C: The large pool is a new area in the Oracle SGA that supports the Recovery Manager tool in recovering the Oracle database. This memory area is optional, and when it is configured, it will improve RMAN performance by offering buffer space in memory for I/O slaves process to use Actualtests.com - The Power of Knowing 1Z0-024 when backing up the database or restoring file components from tape. D: Oracle MTS may also allocate memory from the large pool. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 849-855. Chapter 18: Tuning Memory and Operating System Use QUESTION 28: Database Resource Manager uses resource plans to determine resource limits for the set of users. Which statement is true in reference to resource plans? A. Resource plans are set using profiles. B. Only one resource plan can be stored in the database at one time. C. The database can have many resources plans, but only one can be active at any one time. D. The database can have many resource plans, and each user chooses which plan to belong to. Answer: C Explanation: Only one resource plan can be active at any one time, but the database can have many resources plans. Incorrect Answers: A: Resource plans do not use profiles. B: The database can have many resource plans, not only one. D: The database can have many resource plans, but each user cannot choose which plan to belong to. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 852-854. Chapter 24: Oracle8i New Features Topics QUESTION 29: Which three actions will cause queries to place a table's blocks at the most-recently-used end of the LRU list? (Choose three) A. Creating a table with the CACHE option. B. Querying the table by using a CACHE hint. C. Ensuring the query performs a full table scan. D. Defining the table without the option for caching. E. Altering an existing table to set the CACHE option. F. Ensuring the query does not retrieve data t...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online