1Z0-030

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: 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 Explanation: 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. Incorrect Answers 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 QUESTION 17: 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? A. MERGE B. SELECT ... CROSS JOIN C. INSERT ALL ... SELECT D. CREATE VIEW ... CONSTRAINT Actualtests.com - The Power of Knowing 1Z0-030 Answer: A Explanation: 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. Incorrect Answers 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 QUESTION 18: 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.) A. SWITCH_TIME B. SWITCH_GROUP C. MAX_SESS_POOL D. SWITCH_ESTIMATE Answer: A, B, D Explanation: 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.

Ask a homework question - tutors are online