Incorrect answers b they should not be written to

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: e performance. Incorrect Answers B: They should not be written to disk by the sending instance and read from disk by the receiving instance. Cache Fusion algorithm does not use disk read/write operations to transfer blocks. C: It's not possible to grant by the Global Cache Service an exclusive mode resource for EACH instance involved. Only one instance can have exclusive mode. D: It's not required that these blocks should be transferred through the cache area of the Global Resource Directory on the instance where the block is mastered. OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 223-230 Chapter 4: Performance and Scalability Enhancements Oracle 9i New Features, Robert Freeman, p. 193-206 Chapter 7: Oracle9i Real Application Clusters QUESTION 29: Examine this statement, which creates a Cartesian product of the COUNTRIES and REGION tables: SQL> SELECT c.country_name, 2> r.region name 3> FROM countries c, region r; Oracle9i SQL: 1999 syntax supports the same functionality with which join type? A. Equijoin B. Cross join C. Merge join D. Natural join Answer: B Explanation: The CROSS JOIN operation creates a Cartesian product of two tables. It's the same operation performed when you specify two or more comma-separated tables in the FROM clause without specifying a join condition. Incorrect Answers Actualtests.com - The Power of Knowing 1Z0-030 A: The EQUIJOIN operation requires usage of equity operation. C: The MERGE JOIN operation is used to 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. D: The NATURAL JOIN matches rows that have equal values in all columns that have the same name. OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 242-249 Chapter 5: Language Enhancements Oracle 9i New Features, Robert Freeman, p. 158-161 Chapter 6: Oracle9i SQL, PL/SQL New Features QUESTION 30: Which three table transformations can be done by using online redefinition of tables? (Choose three.) A. Delete rows B. Rename a column C. Change a heap table to an index-organized table D. Change the data type of a column from LONG to BLOB E. Change the data type of a column from DATE to CHAR Answer: B, C, E Explanation: You can add or rename columns, change a heap table to an index-organized table and change the data type of a column from DATE to CHAR by using online redefinition of tables. Incorrect Answers A: Rows deleting is DML operation. It's not a table transformation operation. D: It's not possible to redefine the table online with a LONG column. OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 74-83 Chapter 2: Availability Enhancements Oracle 9i New Features, Robert Freeman, p. 46-53 Chapter 2: Oracle9i Architecture Changes QUESTION 31: You use the TABLESPACES option of the Export command to export, not transport, the contents of...
View Full Document

Ask a homework question - tutors are online