E online and archived log files of the primary

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: evel of Oracle9i. E: Online and archived log files of the primary database need to be available for the standby database. OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 51-74 Chapter 2: Availability Enhancements Oracle 9i New Features, Robert Freeman, p. 86-99 Chapter 3: New Oracle9i Availability and Recoverability Features QUESTION 38: Which operation causes an index to be considered "used" while monitoring is turned on for that particular index? A. Only when the index is specified in a hint B. When data is fetched by an execution plan that uses that index C. When a statement is executed and the execution plan contains a reference to the index D. When a statement is parsed and the resulting execution plan contains a reference to the index Answer: D Explanation: When a statement is parsed and the resulting execution plan contains a reference to the index an index will be considered "used". Incorrect Answers A: It will be considered as "used" when a statement is parsed and the resulting execution plan contains a reference to the index, not only when the index is specified in a hint. B: An index will be considered "used" when a statement is parsed and the resulting execution plan contains a reference to the index, not when data is fetched by an execution plan that uses that index. C: It will be considered as "used" when a statement is parsed and the resulting execution plan contains a reference to the index, not when a statement is executed and the execution plan contains a reference to the index. OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 212-214 Actualtests.com - The Power of Knowing 1Z0-030 Chapter 4: Performance and Scalability Enhancements Oracle 9i New Features, Robert Freeman, p. 56-59 Chapter 2: Oracle9i Architecture Changes QUESTION 39: The multithreaded agent architecture for heterogeneous services is similar to the Oracle multithreaded server architecture. The principal difference is that it uses threads instead of processes. What are three kinds of threads that it uses? (Choose three.) A. TCP B. Task C. Monitor D. Dispatcher E. Shared Server F. Shutdown Address Answer: B, C, D Explanation: The multithreaded Heterogeneous Service (HS) Agents architecture has three kinds of threads: a single monitor thread, several dispatcher threads and several task threads. Incorrect Answers A: The multithreaded HS Agents do not use TCP thread. E: They do not use Shared Server thread. F: The multithreaded HS Agents do not use Shutdown Address thread. OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 148-150 Chapter 3: Manageability Enhancements Oracle 9i New Features, Robert Freeman, p. 59-60 Chapter 2: Oracle9i Architecture Changes QUESTION 40: Which three table transformations can be done using online redefinition of tables? (Choose three.) A. Delete rows B. Drop a column C. Change a heap table to an index-organized table D. Change the data type of a column from LONG to BLOB E. Change a range-partitioned table to...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online