A vqueue b vcircuit c vsession d dbausers e

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: view would show contention for server processes? A. V$QUEUE B. V$CIRCUIT C. V$SESSION D. DBA_USERS E. V$CONNECTION Answer: A Explanation: V$QUEUE view is used show contention for server processes in MTS configuration. Incorrect Answers: B: V$CIRCUIT view is not used to show contention for server processes. This view shows information for users with shared server connections. C: V$SESSION view lists session information for each current session. Links SID to other session attributes. Contains rows lock information. D: DBA_USERS view shows information about all users of Oracle database. E: There is no V$CONNECTION view in Oracle. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 858-859. Chapter 18: Tuning Memory and Operating System Use QUESTION 64: Which class of data describes to Oracle Expert how the database is used in daily operations? A. Schema class B. Workload class C. Instance class D. Environment class Answer: B Explanation: Workload class in Oracle Expert describes how the database is used in daily operations. Incorrect Answers: A: Schema class is used to describe schema structure, not database daily operations usage. C: Instance class is not used for these purposes. D: Environment class of Oracle Expert is not used for these purposes. Actualtests.com - The Power of Knowing 1Z0-024 Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 961-968. Chapter 20: Tuning Other Areas of the Oracle Database QUESTION 65: On a database that is running Multithreaded server, which view would you query to get information for users with shared server connections? A. V$CIRCUIT B. DBA_USERS C. DBA_CIRCUIT D. V$DISPATCHER_USERS E. DBA_DISPATCHERS_USERS Answer: A Explanation: V$CIRCUIT view shows information for users with shared server connections Incorrect Answers: B: DBA_USERS view shows information about all users of Oracle database. C: There is no DBA_CIRCUIT view in Oracle. D: V$DISPATCHER_USERS view does not exist in Oracle. E: There is no DBA_DISPATCHERS_USERS view in Oracle. O...
View Full Document

Ask a homework question - tutors are online