G creating a separate database buffer cache to hold

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: hrough index lookup. G. Creating a separate database buffer cache to hold cached table. Answer: A, B, E Explanation: 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. Incorrect Answers: 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 LRU list. 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 QUESTION 30: 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. Answer: A Explanation: 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. Incorrect Answers: 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 QUESTION 31: 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.

Ask a homework question - tutors are online