D for each row from t2 it updates the row if it

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: -030 name. C. It creates a Cartesian product of table T1 and table T2 for all columns that have the same name. D. For each row from T2, it updates the row if it exists within table T1, otherwise it inserts the row into T1. Answer: D Explanation: Oracle9i introduces the MERGE statement to enable you 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. You can specify the basis for the match with a condition in the ON clause. You specify the UPDATE in the WHEN MATCHED clause and you specify the INSERT in the WHEN NOT MATCHED clause. Incorrect Answers A: For each row from T2, it updates the row if it exists within table T1; otherwise it inserts the row into T1. B: It does not create a natural join of tables T1 and T2. C: It does not create a Cartesian product of table T1 and table T2. 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 DDS and Data-Warehouse Features QUESTION 80: How can you make a shared server-side initialization parameter file available to all instances of a Real Application Clusters database? A. Include an SPFILE parameter in each instance-specific initialization file. B. Create an SPFILE copy on each client from which the instance will be started. C. Store the SPFILE in a raw partition with a vendor-specific location and name. D. Use a single client to start the instances and create the SPFILE on this client. Answer: A Explanation: You can make a shared server-side initialization parameter file available to all instances of a Real Application Clusters database by including an SPFILE parameter in each instance-specific initialization file. You still have to store a copy of the initialization parameter file on each node to facilitate startup of the instances. You can avoid distributing copies by converting this initialization parameter file into a Server Parameter File (SPFILE). Then you put the one parameter, as shown here, in the initialization parameter file for each instance: spfile = oracle/home:\config\spfile Actualtests.com - The Power of Knowing 1Z0-030 Incorrect Answers B: You don't need to create an SPFILE copy on each client from which the instance will be started. C: It is not required to store the SPFILE in a raw partition with a vendor-specific location and name. D: You cannot create the SPFILE on the client. OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 227-230 Chapter 4: Performance and Scalability Enhancements Oracle 9i New Features, Robert Freeman, p. 188-192 Chapter 7: Oracle9i Real Application Clusters QUESTION 81: What are three benefits of performing data definition language (DDL) statements against a partitioned table with the UPDATE GLOBAL INDEXES clause? (Choose three.) A. Global indexes...
View Full Document

Ask a homework question - tutors are online