Unformatted text preview: e
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
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
Examine this statement, which creates a Cartesian product of the COUNTRIES and
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?
B. Cross join
C. Merge join
D. Natural join
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.
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
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
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
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
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
You use the TABLESPACES option of the Export command to export, not
transport, the contents of...
View Full Document
- Fall '09
- Oracle Database, Database management system, new features, Oracle9i, OCP Oracle9i Database