D global indexes on the sales table will be

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: All valid global indexes on the SALES table will retain their USABLE status after the statement completes. D: Global indexes on the SALES table will be maintained concurrently with the exchange operation disregarding if the statement executes with the desired degree of parallelism. OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 130-131 Chapter 3: Manageability Enhancements Oracle 9i New Features, Robert Freeman, p. 102-107 Chapter 4: New Oracle9i Database DDS and Data-Warehouse Features QUESTION 63: In a Data Guard switchover operation, which command must you execute on the database that is being switched from the standby to the primary role? A. ALTER DATABASE MOUNT STANDBY DATABASE; B. ALTER DATABASE BACKUP CONTROLFILE TO TRACE; C. ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL PRIMARY; D. ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY; Answer: C Explanation: This command will switch the database from the standby to the primary role. This statement ensures that all redo log files have been received and that they have been applied up to the end-of-redo marker. It also converts the standby control file to the current control file. Incorrect Answers A: This command just mounts the database as a standby database. B: This command backs up the control file. D: This command closes the primary database, completes the archive task, inserts an end-of-redo marker, and backs up the current control file to the SQL session trace file for conversion to a standby control file. 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 Actualtests.com - The Power of Knowing 1Z0-030 QUESTION 64: Which command can you use to alter the active size of the SGA dynamically, where the entered value differs from the current one? A. ALTER SYSTEM SET SGA_MAX_SIZE=500M ; B. ALTER SYSTEM DROP DB_2K_CACHE_SIZE ; C. ALTER SYSTEM SET DB_CACHE_SIZE=AUTO ; D. ALTER SYSTEM SET SHARED_POOL_SIZE=40M; Answer: D Explanation: This command can be used to alter the active size of the SGA dynamically. Incorrect Answers A: This command is incorrect, because the SGA_MAX_SIZE cannot be changed dynamically. And question was about SGA size dynamic change, not SGA_MAX_SIZE. B: This command is incorrect. You cannot drop the DB_CACHE_SIZE parameter. C: This command is incorrect. You cannot set the DB_CACHE_SIZE parameter as AUTO. OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 180-182 Chapter 3: Manageability Enhancements Oracle 9i New Features, Robert Freeman, p. 16-17 Chapter 1: Oracle9i Database Administration and Management Features QUESTION 65: Which two procedures or functions are part of the DBMS_METADATA package? (Choose two.) A. GET_DDL B. GET_XML C. GET_TYPE D. GET_VIEW E. GET_TABLE Answer: A, B Explanation: The GET_DDL and GET_XML are two function...
View Full Document

Ask a homework question - tutors are online