Incorrect answers a to enable automated sql execution

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: also a dynamic parameter that you can set with the ALTER SYSTEM or ALTER SESSION commands. Incorrect Answers A: To enable Automated SQL Execution Memory Management you don't need to execute the DBMS_STATS.GATHER_SYSTEM_STATS procedure. C: You cannot 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 value. Actualtests.com - The Power of Knowing 1Z0-030 D: You cannot 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. They need to be specified. OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 176-182 Chapter 3: Manageability Enhancements Oracle 9i New Features, Robert Freeman, p. 17-18 Chapter 1: Oracle9i Database Administration and Management Features QUESTION 104: In order to speed foreign key creation, Oracle9i will cache the first _________ primary key values only where there are multirow DML statements. A. 32 B. 128 C. 256 D. 512 Answer: C Explanation: The verification of the existence of a matching primary key before adding a foreign key can consume a significant amount of time. Oracle9i addresses this performance problem by enabling you to cache the first 256 primary keys; this improves the time it takes to verify the existence of a primary key and therefore enhances performance when adding multiple foreign keys. Incorrect Answers A: Oracle9i will cache the first 256 primary keys, not 32. B: Oracle9i will cache the first 256 primary keys, not 128. D: Oracle9i will cache the first 256 primary keys, not 512. OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 260-261 Chapter 5: Language Enhancements Oracle 9i New Features, Robert Freeman, p. 167 Chapter 6: Oracle9i SQL, PL/SQL New Features QUESTION 105: What statement is true about taking a database default temporary tablespace offline? A. You cannot take a default temporary tablespace offline. B. The database must be quiesced before you perform this action. C. You must ensure that all users are assigned to an alternative temporary tablespace first. D. You must first ensure that the default temporary tablespace has the permanent Actualtests.com - The Power of Knowing 1Z0-030 tablespace characteristic. Answer: A Explanation: It's not possible to take a default temporary tablespace offline. Ther are some other restrictions on the default temporary tablespace: you cannot drop a default temporary tablespace until you have created a new default temporary tablespace; you cannot change a default tablespace into a permanent tablespace; you cannot change a permanent tablespace into a temporary tablespace unless it is the SYSTEM tablespace. Incorrect Answers B: The database should not be quiesced before you take a database default temporary tablespace offline. C: You don't need to check that all users are assigned to an alternative temporary tablespace first....
View Full Document

Ask a homework question - tutors are online