This preview shows page 1. Sign up to view the full content.
Unformatted text preview: The Server Manager tool is no longer supplied.
C. The listener must be running to make a connection.
D. The use of a remote password login file (orapw) is unchanged.
Answer: A, B, C
The CONNECT INTERNAL is disallowed in Oracle9i. The Server Manager tool is no
longer supplied also. And the listener must be running to make a connection.
D: The use of a remote password login file (orapw) is changed in Oracle9i.
OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 5-10
Chapter 1: Security Enhancements
Oracle 9i New Features, Robert Freeman, p. 132-135
Chapter 5: Miscellaneous Oracle9i Features and Enhancements
You are responsible for a data warehouse application that uses records from an
external table to update one of the dimension tables periodically. The records in the
external table may contain data for new rows in the dimension table, or for updates
to its existing rows.
Which type of SQL command would you use to transfer the data from the external
table to the dimension table as efficiently as possible?
B. SELECT ... CROSS JOIN
C. INSERT ALL ... SELECT
D. CREATE VIEW ... CONSTRAINT
Actualtests.com - The Power of Knowing 1Z0-030 Answer: A
To transfer the data from the external table to the dimension table as efficiently as
possible you need to use the MERGE command. The MERGE command helps to retrieve
rows from a source table and either update existing rows or insert new rows into a
destination table. You update the row in the destination table if there is a matching row in
the destination table; otherwise, you insert a new row into the destination table.
B: The SELECT ... CROSS JOIN command can be used to create a Cartesian product.
C: The INSERT ALL ... SELECT command will not help you in this case.
D: The CREATE VIEW ... CONSTRAINT cannot be used for purpose to insert new
records or to update existing records in the dimension table.
OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 253
Chapter 5: Language Enhancements
Oracle 9i New Features, Robert Freeman, p. 122-123
Chapter 4: New Oracle9i Database DSS and Data-Warehouse Features
Which three resource plan parameters are used to enable Automatic Consumer
Group Switching to estimate job execution times automatically, and to perform a
switch to a low priority consumer group before they are initiated? (Choose three.)
Answer: A, B, D
You can specify the maximum estimated time to complete (in seconds) for an operation
by assigning a value the MAX_EST_EXEC_TIME parameter; the default value for this
parameter is UNLIMITED. Oracle will estimate the time the operation with table will
take. It the SWITH_ESTIMATE parameter is set to TRUE, and if Oracle's estimate is
greater than the value specified by MAX_EST_EXEC_TIME, Oracle will return an error
and the operation will not be started. If t...
View Full Document
This document was uploaded on 03/08/2014.
- Fall '09