Oracle 8 dba certification exam guide jason s

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: le 8, DBA Certification Exam Guide, Jason S. Couchman, p. 855 Chapter 18: Tuning Memory and Operating System Use QUESTION 2: Which statement could require a sort? A. SELECT DISTINCT dept_ID FROM emp; Actualtests.com - The Power of Knowing 1Z0-024 B. UPDATE emp SET salary=salary*1.1 WHERE id 7722; C. SELECT emp_id, nameFROM emp WHERE emp-id = 7722; D. SELECT emp_id, nameFROM emp WHERE emp-id = BETWEEN 7722 and 7100 ; Answer: A Explanation: Sorts are conducted as part of SELECT DISTINCT, MINUS, INTERSECT, and UNION statements, as well as the min(), max(), and count() operations. Incorrect Answers: B: UPDATE statement does not require a sort operation. C: This SELECT statement does not require a sort operation. D: The BETWEEN clause of SELECT statement does not require a sort operation. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 956-959 Chapter 20: Tuning Other Areas of the Oracle Database QUESTION 3: Which two views can be sued to detect lock contention? (Choose two) A. V$LOCK B. V$LOCKED_OBJECT C. V$LOCK_CONTENTION Answer: A, B Explanation: Two views, V$LOCK and V$LOCKED_OBJECT, are used to detect lock contention. The V$LOCK view lists the locks currently held by the Oracle server and outstanding requests for a lock or latch. The V$LOCKED_OBJECT view lists all locks acquired by every transaction on the system. Incorrect Answers: C: There is no V$LOCK_CONTENTION view in Oracle 8i. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 934-945 Chapter 20: Tuning Other Areas of the Oracle Database QUESTION 4: The database includes tables with static data, which are used for queries only. To which size should you set PCTFREE for this type of table? A. 0 B. 50 C. 20 D. 10 Actualtests.com - The Power of Knowing 1Z0-024 Answer: A Explanation: The PCTFREE parameter is used to specify the amount of space left free in each block to accommodate the growth of existing rows in the block. If the rows in the block will not be updated frequently, or if the updates that will occur will not affect the size of each row, set the value for PCTFREE low on that database object. Incorre...
View Full Document

Ask a homework question - tutors are online