Pctused c initrans d maxtrans e freelists f freelist

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: ameters are ignored when creating an automatic space management segment? (Choose three.) A. PCTFREE B. PCTUSED C. INITRANS D. MAXTRANS E. FREELISTS F. FREELIST GROUPS Answer: B, E, F Explanation: PCTUSED, FREELISTS and FREELIST GROUPS parameters are ignored when creating an automatic space management segment. Oracle9i automatic segment space management maintains information about datablock space utilization in bitmaps, as opposed to freelists. Incorrect Answers A: Usage of automatic space management segment will not eliminate the need to specify the PCTFREE parameter. C: The INITRANS parameter is also used for automatic space management segment. D: The MAXTRANS parameter is also used for automatic space management segment. OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 138-140 Chapter 3: Manageability Enhancements Oracle 9i New Features, Robert Freeman, p. 53-54 Chapter 2: Oracle9i Architecture Changes Actualtests.com - The Power of Knowing 1Z0-030 QUESTION 69: What is the benefit of the Cached Execution Plan feature? A. SQL statement performance is improved. B. The SQL statement no longer needs to be cached in the library cache. C. Improved diagnosability, as the execution plan of a cached SQL statement in memory is preserved. D. The execution plan is available for diagnosis after the SQL statement is aged out of the library cache. Answer: C Explanation: Oracle stores the execution plan of a SQL statement to enable a database administrator (DBA) to analyze the execution plan of a poorly performing SQL statement without having to rerun the query. Oracle9i has introduced the V$SQL_PLAN view to display the cached execution plan, the compilation environment, and the execution statistics of each variable. It also helps the database administrators to determine the actual plan of a query at the time of reported performance problem. Incorrect Answers A: The Cached Execution Plan feature helps to diagnose the execution plan, not to improve SQL statement performance itself. B: The SQL statement still needs to be cached in the library cache. The Cached Execution Plan does not eliminate this need. D: The execution plan is available for diagnosis when the SQL statement is in the library cache. OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 217-218 Chapter 4: Performance and Scalability Enhancements Oracle 9i New Features, Robert Freeman, p. 185-186 Chapter 6: Oracle9i SQL, PL/SQL New Features QUESTION 70: When querying the new v$spparameter view, the column ISSPECIFIED displays the value TRUE for a number of parameters. What does this mean? A. The value for the parameters is TRUE. B. The parameters are specified in the PFILE parameter file C. The parameters are specified in the SPFILE parameter file. D. Changes to the parameter are only in the currently running instance. Answer: C Explanation: Actualtests.com - The Power of Knowing 1Z0-030 The column ISSPECIFIED displays the value TRUE for the parameters specified in the SPFIL...
View Full Document

Ask a homework question - tutors are online