Couchman p 767 768 chapter 16 introducing database

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: Certification Exam Guide, Jason S. Couchman, p. 767-768. Chapter 16: Introducing Database Tuning QUESTION 50: When a parallel query is used to perform a sort, what is the total amount of memory a factor to? Actualtests.com - The Power of Knowing 1Z0-024 A. SORT_AREA_SIZE * 2 B. SORT_AREA_SIZE * degree of parallelism. C. SORT_AREA_SIZE *2* degree of parallelism. D. SORT_AREA_SIZE * divided up equally among the parallel query servers. E. SORT_AREA_SIZE * parallel query server take turns at using the memory. Answer: C Explanation: SORT_AREA_SIZE *2* degree of parallelismis correct formula to calculate the total amount of memory to perform a sort. Incorrect Answers: A: This formula does not represent correct amount of memory to perform a sort. B: This amount needs to be multiplied on 2 to be correct amount of memory for sorts. D: This formula has nothing to do with parallel query servers. E: This formula has nothing to do with parallel query server. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 956-961. Chapter 20: Tuning Other Areas of the Oracle Database QUESTION 51: How are deadlocks resolved within Oracle? A. The DBA must terminate the waiting session. B. The DBA must terminate the blocking session. C. Oracle detects deadlocks automatically and rolls back the statement which detects the deadlock. D. TopSessions monitors long running transactions and terminates any session which holds a lock longer than the limit specified by LOCK_THRESHOLD Answer: C Explanation: Oracle detects deadlocks automatically and rolls back the statement which detects the deadlock. Incorrect Answers: A: The DBA should not do anything if deadlocks are resolved within Oracle. B: The DBA should not do anything if deadlocks are resolved within Oracle. D: TopSessions utility only monitors sessions, it will not terminate any session automatically. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 942-945. Chapter 20: Tuning Other Areas of the Oracle Database QUESTION 52: When a deadlock occurs, what should be used to diagnose the proble...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online