New Features for Administrators - Question 070

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:

The column ISSPECIFIED displays the value TRUE for the parameters specified in the SPFILE parameter file.

Incorrect Answers

A: This column does not show the value of the parameter itself.

B: The parameters are specified in the SPFILE parameter file, not in the PFILE parameter file.

D: These changes will be saved in the SPFILE parameter file, so they will be active after instance restart also.

OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 80-83

Chapter 2: Availability Enhancements

Oracle 9i New Features, Robert Freeman, p. 35-36

Chapter 1: Oracle9i Database Administration and Management Features