46 53 chapter 2 oracle9i architecture changes

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: l Benjamin, p. 78-80 Chapter 2: Availability Enhancements Oracle 9i New Features, Robert Freeman, p. 46-53 Chapter 2: Oracle9i Architecture Changes QUESTION 92: What type of protection is implemented when the DBA issues the ALTER DATABASE SET STANDBY DATABASE PROTECTED; command? A. The standby database is protected against write operations B. The primary database is protected against write operations C. The primary database is protected against data loss and data divergence D. The standby database is protected against data loss and data divergence Answer: C Explanation: The failure resolution policy specifies what should happen on the primary database if all the standby databases ion the configuration are unable to archive the redo logs. To specify guaranteed protection, you must establish the PROTECTED mode for the primary database. The PROTECTED mode will establish a zero divergence and zero data loss configuration. Incorrect Answers A: The standby database is not protected against write operations by this operation. The standby database can be mounted for recovery or open as read-only database. B: The primary database is not protected against write operations. D: The primary, not standby, database is protected against data loss and data divergence. Actualtests.com - The Power of Knowing 1Z0-030 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 93: An index-organized table (IOT) called SPARSE has had many records deleted. Which command reorganizes the IOT so that the empty space is removed, while minimizing the impact for users? A. EXPORT with TABLES and IMPORT with the INDEX and IGNORE options. B. ALTER TABLE _ COALESCE ; C. ALTER INDEX _ REBUILD ONLINE ; D. CREATE TABLE _ AS SELECT _ ONLINE; Answer: B Explanation: The ALTER TABLE table_name COALESCE statement will reorganize the IOT. The rebuild operation creates a new tree to defragment the index, as opposed to the coalesce operation that coalesces the leaf blocks within the same branch of the tree. Incorrect Answers A: You cannot do this using EXPORT and IMPORT with specified options. There is no INDEX option in EXPORT utility. Only INDEXES option exists. C: This command can be used to rebuild the secondary index of IOT only. D: This command is incorrect: you cannot use the ONLINE option that way. OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 76-78 Chapter 2: Availability Enhancements Oracle 9i New Features, Robert Freeman, p. 46-53 Chapter 2: Oracle9i Architecture Changes QUESTION 94: What does the Character Set Scanner command line utility do? A. Reports only on any Unicode character conversions required B. Performs character set conversions to the new specified character set C. Scans on any character set conversion required, then converts the data D. Checks for any character definitions that will fail conversion to the new character set Answer: D Explanation: Oracle9i provides you with the Character Set Scanner...
View Full Document

Ask a homework question - tutors are online