C createconsumergroup will be used later it is not

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: N procedure will be used after CREATE_PENDING_AREA procedure. C: CREATE_CONSUMER_GROUP will be used later, it is not first one. D: CREATE_PLAN_DIRECTIVE will be used also later. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 1149. Chapter 24: Oracle8i New Features Topics QUESTION 87: What can database resource manager help you to limit for a set of users? A. Amount of I/O performed. B. Maximum connection time. C. Number of concurrent sessions. D. Number of Parallel Query servers available. Answer: D Explanation: The database resource manager can help you to limit the number of Parallel Query servers available for a set of users. Incorrect Answers: A: The database resource manager cannot control amount of I/O operations to be performed for a set of users. B: The database resource manager will not help you to limit maximum connection time for a set of users. C: The database resource manager cannot control the number of concurrent sessions for a set of users. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 1149. Chapter 24: Oracle8i New Features Topics QUESTION 88: Which single dynamic view is the most useful for determining buffer cache performance when using multiple buffer pools? A. V$SYSSTAT B. V$BUFFER_POOL C. V$SYSTEM_EVENT D. V$BUFFER_POOL_STATISTICS Answer: D Actualtests.com - The Power of Knowing 1Z0-024 Explanation: The V$BUFFER_POOL_STATISTICS view is the most useful for determining buffer cache performance when using multiple buffer pools. You can use this view to calculate buffer-cache hit ratios for your multiple buffer pools. Incorrect Answers: A: Determining the buffer-cache hit ratio depends on the proper use of the performance view V$SYSSTAT, but V$BUFFER_POOL_STATISTICS will provide more useful information for determining buffer cache performance when using multiple buffer pools. B: The V$BUFFER_POOL view will work also, but it is not so informative for multiple buffer pools as the V$BUFFER_POOL_STATISTICS view. C: The V$SYSTEM_EVEN...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online