When the master definition site is not the same for

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: . When the master definition site is not the same for all of the master groups D. Without impacting end users who are executing data manipulation language (DML) commands on the replicated tables Answer: D Explanation: It's possible to add a new master to a replication group without quiescing the group without impacting end users who are executing data manipulation language (DML) commands on the replicated tables. Incorrect Answers A: The new master site already may not have existing replication groups to achieve this result. B: You cannot add a new master to a replication group without quiescing the group by Actualtests.com - The Power of Knowing 1Z0-030 issuing a single command to create, populate, and activate the new master. C: When the master definition site is not the same for all of the master groups you cannot add a new master to a replication group without quiescing the group. OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 83-93 Chapter 2: Availability Enhancements Oracle 9i New Features, Robert Freeman, p. 146-147 Chapter 5: Miscellaneous Oracle9i Features and Enhancements QUESTION 23: The DBMS_STATS.GATHER_SYSTEM_STATS routine collects system statistics in a user-defined time frame. Which four statements are true of the GATHER_SYSTEM_STATS routine? (Choose four.) A. You can use the GATHERING_MODE => 'END' option to end system statistics collection. B. You can use the INTERVAL option to specify a fixed interval to collect statistics. C. You can use the GATHERING_MODE => 'START' option to enable manual statistics collection. D. The routine allows the optimizer to consider a system's CPU and I/O utilization and performance. E. The routine allows the optimizer to invalidate existing cached plans. Answer: A, B, C, D Explanation: You can use the GATHERING_MODE => 'END' option to end system statistics collection, the GATHERING_MODE => 'START' option to enable manual statistics collection. The INTERVAL option is used to specify a fixed interval to collect statistics. The routine allows the optimizer to consider a system's CPU and I/O utilization and performance. Incorrect Answers E: The routine does not allow the optimizer to invalidate existing cached plans. OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 220-222 Chapter 4: Performance and Scalability Enhancements Oracle 9i New Features, Robert Freeman, p. 180-185 Chapter 6: Oracle9i SQL, PL/SQL New Features QUESTION 24: Examine this startup script called startmydb.sql: CONNECT myid/mypwd AS SYSDBA STARTUP EXIT In Oracle8i, you could have executed this script by invoking Server Manager with Actualtests.com - The Power of Knowing 1Z0-030 the command: svrmgrl @startmydb.sql Which alternative command could you use to run the startmydb.sql script with SQL*Plus to start your Oracle9i database? A. sqlplus @startmydb.sql B. sqlplus -Sstartmydb.sql C. sqlplus -S @startmydb.sql D. sqlplus /NOLOG @startmydb.sql Answer: D Explanation: This command is alternate command to start your Oracle9...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online