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: benefits of index-organized tables? (Choose two) A. More concurrency. B. Faster full table scans. C. Fast primary key-based access. D. Less contention on the segment header. E. No duplication of primary key values storage. Answer: C, E Explanation: Index-organized tables provide fast primary key-based access and no duplication of primary key values storage. Incorrect Answers: A: Iindex-organized tables do not provide additional concurrency. B: IOT is not used for faster full table scans. D: Less contention on the segment header is not main benefit of IOT. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 792. Chapter 17: Tuning Database Applications QUESTION 48: Which view shows the number of full table scan? Actualtests.com - The Power of Knowing 1Z0-024 A. V$SYSSTAT B. V$FILESTAT C. V$SESSIONS D. V$DATAFILE Answer: A Explanation: V$SYSSTAT view shows the number of full table scans. This view contains general statistics for the instance by name. Incorrect Answers: B: V$FILESTAT view is used to check I/O bottlenecks on datafiles. C: V$SESSIONS view lists session information for each current session. Links SID to other session attributes. Contains rows lock information. D: V$DATAFILE dictionary view shows information about data files of Oracle database. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 766-767. Chapter 16: Introducing Database Tuning QUESTION 49: Which two views would you query to monitor sessions related statistics? (Choose two) A. V$SESSTAT B. V$SESSION_EVENT C. V$SESSION_STATS D. V$SESSION_STATUS E. V$WAITS_PER_SESSION Answer: A, B Explanation: V$SESSTAT and V$SESSION_EVENT views are used to monitor sessions related statistics. V$SESSTAT lists user session statistics, requires join to V$STATNAME and V$SESSION views. V$SESSION_EVENT view lists information on waits for an event by a session. Incorrect Answers: C: There is no V$SESSION_STATS view in Oracle. D: V$SESSION_STATUS view does not exist in Oracle. E: There is no V$WAITS_PER_SESSION view in Oracle. Oracle 8, DBA...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online