This preview shows page 1. Sign up to view the full content.
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
Index-organized tables provide fast primary key-based access and no duplication of primary key
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
Which view shows the number of full table scan? Actualtests.com - The Power of Knowing 1Z0-024
V$SYSSTAT view shows the number of full table scans. This view contains general statistics
for the instance by name.
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
Which two views would you query to monitor sessions related statistics? (Choose two)
Answer: A, B
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.
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.
- Fall '09