Unformatted text preview: must be at least 50 blocks.
C: 30 buffers are not enough for an LRU latch, there must be at least 50 blocks.
D: 100 buffers will be enough for an LRU latch, but the minimum number is 50 blocks, not 100.
Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 867-872.
Chapter 18: Tuning Memory and Operating System Use
Which three statements about rebuilding indexes are true? (Choose three)
A. The ALTER INDEX REBUILD command is used to change the storage characteristics of an
B. Using the ALTER INDEX REBUILD is usually faster than dropping and recreating an index
Actualtests.com - The Power of Knowing 1Z0-024
because it uses the fast full scan feature.
C. Oracle8i allows for the creation of an index or re-creation of an existing index while allowing
concurrent operations on the base table.
D. When building an index, the NOLOGGING and UNRECOVERABLE keywords can be used
concurrently to reduce the time it takes to rebuild.
Answer: A, B, C
It's possible to change the storage parameters of an index with ALTER INDEX REBUILD
command. This command usually faster than dropping and recreating an index because of fast
full scan feature. Users can perform concurrent operations on the base table during the creation
or re-creation of an index in Oracle8i.
D: Usage of NOLOGGING keyword can reduce the time to rebuild index, but not an
Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 917-918.
Chapter 19: Tuning Disk utilization
Where can you find the nondefault parameters when the instance is started?
A. Alert log
B. Online redo log
C. Archived redo log
D. SYSTEM user's trace file
You can find non-default parameters for started instance in Alert log file.
B: Online redo logs do not contain non-default Oracle parameters for instance.
C: Archived redo logs do not contain non-default Oracle parameters for instance, it's just
archived version of online redo logs.
D: Trace file for SYSTEM user can not...
View Full Document
- Fall '09
- Oracle Database, Jason S. Couchman, DBA Certification Exam, Certification Exam Guide