This preview shows page 1. Sign up to view the full content.
Unformatted text preview: hrough index lookup.
G. Creating a separate database buffer cache to hold cached table.
Answer: A, B, E
Creating a table with the CACHE option, querying the table by using a CACHE hint, altering an
existing table to set the CACHE option will cause queries to place a table's blocks at the
Actualtests.com - The Power of Knowing 1Z0-024
most-recently used end of the LRU list.
C: If the query performs a full table scan you cannot be sure that all table's blocks will be placed
at the most-recently used end of the LRU list.
D: Defining the table without the option for caching will not put table in the most-recently used
end of the LRU list.
F: The query, which does not retrieve data through index lookup, will not put data in the top of
G: A separate database buffer cache have nothing to do with cached table.
Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 873.
Chapter 18: Tuning Memory and Operating System
What is the main reason to create a reverse key index on a column?
A. The column is populated using a sequence.
B. The column contains many different values.
C. The column is mainly used for value range scans.
D. The column implementing an inverted list attribute.
It's reasonable to use a reverse key index on a column if it is populated using a sequence. Oracle
recommends to use cost-based optimization with reverse-key indexes.
B: The column, which contains many different values, requires B-tree index, not a reverse key
index for better performance.
C: The reverse key index will not give good performance for the column, which is mainly used
for value range scans.
D: There is no an inverted list attribute for columns in Oracle.
Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 811-812.
Chapter 17: Tuning Database Applications
Which type of table is the best candidate to be cached?
A. Small table rarely retrieved with a full table scan.
B. Large table rarely retrieved with...
View Full Document
This document was uploaded on 03/08/2014.
- Fall '09