Ora file oracle 8 dba certification exam guide jason

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: SOURCE_MANAGER_PLAN parameter in init.ora file. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 1149. Chapter 18: Oracle8i New Features Topics QUESTION 43: Why do these steps eliminate row migration? Step 1: Run ANALYSE TABLE . . . . . LIST CHAINED ROWS command Step 2: Copy the rows to another table Step 3: Delete the rows from the original table Step 4: Insert the rows from step 2 back into the original table. A. Migration only occurs during an UPDATE operation. B. The migrated rows are removed with the DELETE command. C. Migration is automatically removed with the ANALYZE command. Answer: A Explanation: These steps will eliminate row migration because it happens only during an UPDATE operation. Incorrect Answers: B: The migrated rows will be inserted again after deleting into the original table, but they will fit database blocks, because migration happens only after an UPDATE operation, not after INSERT. C: ANALYZE command will not fix migration problem automatically. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 915-916. Chapter 19: Tuning Disk Utilization QUESTION 44: After running a query using V$DISPATCHER, you increase the number of dispatchers. What would cause you to take this action? A. Users are waiting on a listener process. B. Users are waiting on dispatch processes. C. Users are waiting on shared server processes. Actualtests.com - The Power of Knowing 1Z0-024 D. Users are waiting on their dedicated connection process. Answer: B Explanation: If V$DISPATCHER view shows you that users are waiting on dispatch process, you need to increase the number of dispatchers running for Oracle instance. Incorrect Answers: A: V$DISPATCHER view have nothing to do with a listener process. C: Users do not work with shared server processes directly, users use dispatchers in MTS environment to connect to database. D: Users do not wait for dedicated connection process, because Oracle will launch the new dedicated process if there is no more idle dedicated process for user and number of dedicated processes did not exce...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online