D you cannot have more than one dimension table being

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: ng in the join condition of the bitmap join index definition cannot be updated concurrently. D. You cannot have more than one dimension table being part of the join condition of a bitmap join index definition. Answer: C 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 A: You cannot reference an IOT or a temporary table. B: You cannot reference an IOT or a temporary table. D: 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. 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 QUESTION 102: What are the two methods used to add a second, or subsequent, block size to an existing database? (Choose two.) A. Create a new tablespace and include a block size specification. B. Transport a tablespace with a different block size into the database C. Re-create the control file to specify a new block size for specific data files D. Take a tablespace offline, and then put it back online with a new block size specification. Answer: C, D Actualtests.com - The Power of Knowing 1Z0-030 Explanation: You can re-create the control file to specify a new block size for specific data files. Other way to do that: take a tablespace offline, then put it back online with a new block size specification. Incorrect Answers A: This method is not used to add a second, or subsequent, block size to an existing database. B: You cannot transport a tablespace with a different block size. OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 164-166 Chapter 3: Manageability Enhancements Oracle 9i New Features, Robert Freeman, p. 13 Chapter 1: Oracle9i Database Administration and Management Features QUESTION 103: What must you do to enable Automated SQL Execution Memory Management? A. Execute the DBMS_STATS.GATHER_SYSTEM_STATS procedure with appropriate values B. Set the instance parameters PGA_AGGREGATE_TARGET and WORKAREA_SIZE_POLICY to appropriate values. C. Set the instance parameters SORT_ AREA_ SIZE, BITMAP_MERGE_AREA_SIZE, CREATE_BITMAP_AREA_SIZE, HASH_AREA_SIZE, SORT_AREA_SIZE, and SORT_AREA_RETAINED_SIZE all to AUTO. D. Unset the instance parameters SORT_AREA_SIZE, BITMAP_MERGE_AREA_SIZE, CREATE_BITMAP_AREA_SIZE, HASH_AREA_SIZE, SORT_AREA_SIZE, and SORT_AREA_RETAINED_SIZE. Answer: B Explanation: PGA_AGGREGATE_TARGET is a new instance-level parameter that specifies the total memory in KB, MB, or GB for the PGA of all the sessions combined. This is a dynamic parameter; you can set this parameter with the ALTER SYSTEM command. Oracle9i gives you a second parameter, WORKAREA_SIZE_POLICY, to specify the work-areasizing mechanism. This is...
View Full Document

Ask a homework question - tutors are online