B you do not have to search for invalid global

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: are rebuilt automatically at the end of the DDL operation thereby avoiding problems with the UNUSABLE status. B. You do not have to search for invalid global indexes after the DDL command completes and rebuild them individually C. Global indexes are maintained during the operation of the DDL command and therefore can be used by any concurrent query D. Global indexes remain intact and available for use by data manipulation language (DML) statements even for sessions that have not enabled the skipping of unusable indexes. Answer: A, B, D Explanation: Oracle9i overcomes the problem of rebuilding the global index by giving you the option to update global indexes as Oracle performs the partition DDL. This feature is not applicable to local indexes, domain indexes, index-organized tables (IOTs), or to indexes that were UNUSABLE prior to start of the partition DML. You can invoke this capability by using the optional clause UPDATE GLOBAL INDEX of the ALTER TABLE command. You can use this clause with the ADD, COALESCE, DROP, EXCHANGE, MERGE, MOVE, SPLIT, and TRUNCATE partition DDL commands. Incorrect Answers C: Global indexes are not maintained during the operation of the DDL command. 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 82: Actualtests.com - The Power of Knowing 1Z0-030 In the Oracle9i Data Guard architecture, what is the purpose of the Log Transport Services? A. To transfer redo log information to one or more destinations B. To apply redo log records sent from the primary database to a standby database at the receiving location C. To synchronize changes to the control files on all standby databases with changes on the primary database when a log switch occurs D. To batch archived log files on the primary database until a defined number of checkpoints have been processed and then to distribute the archives to each standby database Answer: A Explanation: The Log Transport Service is comprised of several processes. On the primary database site, the Log Writer updates the online redo logs with the transactions. It can also update the local archived redo logs and send online redo logs transactions to the standby databases. The Archiver saves the online redo log transactions on either local or standby archive logs. The Fetch Archive Log (FAL) client gets redo log transactions from the primary database. When it detects an archive log gap on the standby database, it initiates a request to the FAL server to automatically send and archive the primary database's redo log transactions. The FAL server exists on the primary database server, and it services requests from FAL clients. Incorrect Answers B: The Log Application Service applies the archived redo logs to the standby database. C: Log Transport Services cannot synchronize changes to the control files on all standby databases with changes on the...
View Full Document

Ask a homework question - tutors are online