You can query the vobjectusage view to review the

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: uery the V$OBJECT_USAGE view to review the index utilization data. If the index has been used within the period of time it was monitored, the USED column within this view will contain a YES value; it will contain a NO otherwise. Incorrect Answers B: During a query's execution time Oracle9i does not flag an index as being used in the V$OBJECT_USAGE view. C: Oracle9i flags an index as being used in the V$OBJECT_USAGE view during a query's parse time, not during any kind of DML statement execution. D: Oracle9i flags an index as being used in the V$OBJECT_USAGE view during a query's parse time, not during execution of an INSERT statement. OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 212-214 Chapter 4: Performance and Scalability Enhancements Oracle 9i New Features, Robert Freeman, p. 56-57 Chapter 2: Oracle9i Architecture Changes QUESTION 13: The list below displays four steps that you need to execute in order to switch from Actualtests.com - The Power of Knowing 1Z0-030 the primary database role to the standby database role. Choose the correct order of execution for the steps. 1. Shut down and start up the former primary instance without mounting the instance. 2. Issue the ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY command. 3. Issue the ALTER DATABASE MOUNT STANDBY DATABASE command. 4. End read or update activity on the former primary and standby databases. A. 1, 2, 3, 4 B. 3, 2, 4, 1 C. 4, 2, 1, 3 D. 4, 3, 2, 1 Answer: C Explanation: To switch from the primary database role to the standby database role you need to end to read or update activity on the former primary and standby databases, issue the ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY command, shut down and start up the former primary instance without mounting the instance, issue the ALTER DATABASE MOUNT STANDBY DATABASE command. Incorrect Answers A: First you need to end to read or update activity on the former primary and standby databases. B: You need to issue the ALTER DATABASE MOUNT STANDBY DATABASE command after the former primary database have been switched to standby mode. D: You need to switch the former primary database to standby mode and restart instance before you mount the former primary instance in standby mode. OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 64-72 Chapter 2: Availability Enhancements Oracle 9i New Features, Robert Freeman, p. 86-99 Chapter 3: New Oracle9i Availability and Recoverability Features QUESTION 14: Media recovery can sometimes be stopped by the inability to read past a certain point in the redo stream. This is often referred to as "stuck recovery." Before Oracle9i, the Database Administrator had few options to deal with stuck recovery. If the corrupt redo could not be recovered from some other source, then all transactions that committed after the corrupt point in the redo stream would be lost. Oracle9i changes that with the Trial Recovery feature. Trial Recovery is used to test the application of the redo logs to the database....
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online