Unformatted text preview: racle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 858-859.
Chapter 18: Tuning Memory and Operating System Use
To provide more free lists for a number of your database segments, what is one of your
A. Modify them with the INSERT_ _ FREELIST command.
B. Drop and re-create them with the required FREELIST value.
C. Change the default storage parameter of the tablespace(s) where they are stored.
D. Modify the FREELIST_LIMIT parameter in your installation file and restart the instance.
There is one option to change number of free lists for the database segment: drop and recreate
the database segment with required FREELIST value. Oracle maintains list of blocks that have
space available for data insertion for all tables, called FREELISTS.
A: This command will not change free list value for the database segment.
C: Change of the default storage parameter for the tablespace will not modify free list parameter
for the database segment.
Actualtests.com - The Power of Knowing 1Z0-024
D: There is no FREELIST_LIMIT parameter in the installation file.
Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 945-947.
Chapter 20: Tuning Other Areas of the Oracle Database
Which statement is true when connecting to the Oracle instance using the multithreaded
A. The User Global Area (UGA) may only contain sort areas.
B. The User Global Area (UGA) may be accessible to dedicated servers.
C. The User Global Area (UGA) components may reside in the large pool.
D. The User Global Area (UGA) components may reside in the buffer cache.
User Global Area (UGA) components may reside in the large pool in MTS configuration.
A: UGA stands for User Global Area, and it represents the amount of memory allocated in
Oracle for a user session. So it may contain not only sort areas.
B: In dedicated configuration session information, such as private SQL area, is stored in the
memory allocated to the user process and...
View Full Document
- Fall '09
- Oracle Database, Jason S. Couchman, DBA Certification Exam, Certification Exam Guide