Unformatted text preview: ameters are ignored when creating an automatic space
management segment? (Choose three.)
F. FREELIST GROUPS
Answer: B, E, F
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.
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.
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.
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
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
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.
Actualtests.com - The Power of Knowing 1Z0-030
The column ISSPECIFIED displays the value TRUE for the parameters specified in the
View Full Document
This document was uploaded on 03/08/2014.
- Fall '09