This preview shows page 1. Sign up to view the full content.
Unformatted text preview: from the large pool.
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
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.
Only one resource plan can be active at any one time, but the database can have many resources
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
Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 852-854.
Chapter 24: Oracle8i New Features Topics
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.
- Fall '09