Build to extract the information from the database d

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: ='DDL'; C. You must wait until after hours, shut the database down, and issue the command EXECUTE DBMS_LOGMNR_D.BUILD to extract the information from the database. D. The task cannot be done. LogMiner does not track DDL commands in Oracle9i. Answer: A Explanation: Prior to Oracle9i, DDL statements were recorded as a set of DML statements on internal tables. It was no simple task to review these DML statements and realize that a DDL operation had been performed. You could almost forget this when trying to determine the actual DDL statement that sourced these DML statements. Oracle 9i records the original DDL statement in the redo logs, and LogMiner lists this DDL statement followed by the set of generated DML statements. When you query V$LOGMNR_CONTENTS, you can see DDL under the OPERATION column, and the DDL statement itself under the SQL_REDO column. Incorrect Answers Actualtests.com - The Power of Knowing 1Z0-030 B: This view does not provide the requested information. There are no USERNAME, OPERATION, SQL_REDO and OPERATION columns in this view. C: You don't need to wait until after hours, shutdown database to retrieve this information. The V$LOGMNR_CONTENTS dynamic view can be used for this purpose. D: This task can be done with the V$LOGMNR_CONTENTS dynamic view. OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 100-110 Chapter 2: Availability Enhancements Oracle 9i New Features, Robert Freeman, p. 68-72 Chapter 3: New Oracle9i Availability and Recoverability Features QUESTION 78: Which is a restriction on a list partitioned table? A. You cannot create global range partitioned indexes on the table. B. The optimizer will not execute partition wise joins on the table's partitions. C. You must include at least one element in the value list of each partition of the table, even if that element is the keyword NULL. D. Partition pruning will not occur during query optimization if a range of values is included in the query predicate. Answer: C Explanation: At least one element needs to be defined for each partition of the table. The set of values that specifies a partition cannot be empty; it must contain at least one value. Incorrect Answers A: You can create global range partitioned indexes on the table. B: The optimizer will execute partition wise joins on the table's partitions. D: Partition pruning will occur during query optimization if a range of values is included in the query predicate. OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 134-136 Chapter 3: Manageability Enhancements Oracle 9i New Features, Robert Freeman, p. 102-107 Chapter 4: New Oracle9i Database DDS and Data-Warehouse Features QUESTION 79: Consider this syntax: MERGE INTO tl USING t2 ON (join predicate)..... What does the MERGE syntax do? A. It performs a merge join of the row from T2 only if it doesn't exist in the T1 table. B. It creates a natural join of tables T1 and T2 for all columns that have the same Actualtests.com - The Power of Knowing 1Z0...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online