C small table frequently retrieved with a full table

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: a full table scan. C. Small table frequently retrieved with a full table scan. D. Large table frequently retrieved with a full table scan. Answer: C Actualtests.com - The Power of Knowing 1Z0-024 Explanation: The best candidate to be cached is small table frequently retrieved with a full table scan. Incorrect Answers: A: If table is rarely retrieved with a full table scan it's not necessary to keep it in cache. B: If table is large and rarely retrieved with a full table scan it's not necessary to keep it in cache. D: It's difficult to keep large table in the cache, it must be small enough to fit the cache. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 873. Chapter 18: Tuning Memory and Operating System Use QUESTION 32: Which initialization parameter specifies the location of the alert log file? A. UTL_FILE_DIR B. USER_DUMP_DEST C. LOG_ARCHIVE_DEST D. BACKGROUND_DUMP_DEST Answer: D Explanation: The location of your alert log and background trace files depends on the directory specified for the BACKGROUND_DUMP_DEST for your instance. Incorrect Answers: A: UTL_FILE_DIR is used for different purpose, not for alert log file storage. B: USER_DUMP_DEST parameter specifies for user dump files, not alert log file. D: LOG_ARCHIVE_DESC parameter shows directory where all archived log files are located. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 754-759. Chapter 16: Introducing Database Tuning QUESTION 33: The NOLOGGING mode in SQL statements is a tool used to reduce redo operations, but NOLOGGING does not apply to every operation for which the attribute is set. Which three SQL statements can use the NOLOGGING mode to reduce redo operations? (Choose three) A. UPDATE B. CREATE INDEX C. ALTER INDEX. . REBUILD D. Conventional Path INSERT E. CREATE TABLE. . . . AS SELECT Answer: B, C, E Actualtests.com - The Power of Knowing 1Z0-024 Explanation: There are three statements can use NOLOGGING mode to reduce redo operations: CREATE INDEX, ALTER INDEX ... REBUILD,...
View Full Document

Ask a homework question - tutors are online