C 30 buffers are not enough for an lru latch there

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: 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 QUESTION 20: 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 index. 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 Explanation: 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. Incorrect Answers: D: Usage of NOLOGGING keyword can reduce the time to rebuild index, but not an UNRECOVERABLE keyword. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 917-918. Chapter 19: Tuning Disk utilization QUESTION 21: 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 Answer: A Explanation: You can find non-default parameters for started instance in Alert log file. Incorrect Answers: 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

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online