|
Explanation: The column ISSPECIFIED displays the value TRUE for the parameters specified in the SPFILE parameter file. Incorrect Answers: 1: This column does not show the value of the parameter itself. 2: The parameters are specified in the SPFILE parameter file, not in the PFILE parameter file. 4: These changes will be saved in the SPFILE parameter file, so they will be active after instance restart also. Reference: 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
|