This preview shows page 1. Sign up to view the full content.
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
D. The task cannot be done. LogMiner does not track DDL commands in Oracle9i.
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
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
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
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.
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.
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
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.
- Fall '09