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
Answer: A, B, D
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.
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
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
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.
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
- Fall '09
- Oracle Database, Database management system, new features, Oracle9i, OCP Oracle9i Database