B data tablespace is used for data storage not for

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: space by default in Oracle. B: DATA tablespace is used for data storage, not for data sorts, so it must not to be used as temporary tablespace. It will not be set as TEMPORARY TABLESPACE for user by default. D: ROLLBACK tablespace is used for rollback segments information, not for data sorts, as temporary tablespase is used. It will not be set as TEMPORARY TABLESPACE for user by default. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 953-955. Chapter 20: Tuning Other Areas of the Oracle Database QUESTION 14: Which dynamic view is most useful for determining the current number of blocks allocated to a buffer pool? A. V$CACHE B. V$SESS_IO C. V$SYSSTAT D. V$BUFFER_POOL Answer: D Explanation: The most useful dynamic view for determining the current number of blocks allocated to a buffer pool. Incorrect Answers: Actualtests.com - The Power of Knowing 1Z0-024 A: V$CACHE does not exist in Oracle8i. It's Oracle9i Real Application Clusters view. This view contains information from the block header of each block in the SGA of the current instance as related to particular database objects: http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=180853. B: V$SESS_IO view is used for I/O statistics for session, not for determining the current number of blocks allocated to a buffer pool. C: V$SYSSTAT view is used to determine the buffer-cache ratio, but it does not show the current number of blocks allocated to a buffer pool. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 872-873. Chapter 18: Tuning Memory and Operating System Use QUESTION 15: Which three statements about improving the performance of the database buffer cache by creating multiple buffer pools are true? (Choose three) A. One, two, or three pools may be defined. B. There are at least 50 blocks per LRU latch for each pool. C. Each buffer pool is assigned latches taken from DB_BLOCK_LRU_LATCHES. D. The size of the DEFAULT pool is obtained by adding all the pools to the value of t...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online