Unformatted text preview: a full
C. Small table frequently retrieved with a full table scan.
D. Large table frequently retrieved with a full table scan.
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.
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
Which initialization parameter specifies the location of the alert log file?
The location of your alert log and background trace files depends on the directory specified for
the BACKGROUND_DUMP_DEST for your instance.
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
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
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
There are three statements can use NOLOGGING mode to reduce redo operations: CREATE
INDEX, ALTER INDEX ... REBUILD,...
View Full Document
- Fall '09
- Oracle Database, Jason S. Couchman, DBA Certification Exam, Certification Exam Guide