|
Explanation: Tables participating in the join condition of the bitmap join index definition cannot be updated concurrently. Only one table can be updated concurrently by different transactions. Incorrect Answers: 1: You cannot reference an IOT or a temporary table. 2: You cannot reference an IOT or a temporary table. 4: You can have more than one dimension table being part of the join condition of a bitmap join index definition. Bitmap join index optimizes the joining of two or MORE tables. Reference: OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 142-143 Chapter 3: Manageability Enhancements Oracle 9i New Features, Robert Freeman, p. 54-56 Chapter 2: Oracle9i Architecture Changes
|