New Features for Administrators - Question 095

What is true regarding a shared, server-side parameter file for a Real Application Clusters database?

A. It can contain parameters with distinct values for each instance.

B. It can contain only parameters with identical values for each instance.

C. It must contain an IFILE parameter for each instance's individual parameter file.

D. It must be located in the default location for the primary instance's parameter file.

Answer: A

Explanation:

The server-side parameter file for a Real Application Clusters database can contain parameters with distinct values for each instance.

Incorrect Answers

B: It can contain not only parameters with identical values for each instance, but distinct values for each instance.

C: It is not required that it must contain an IFILE parameter for each instance's individual parameter file. It needs to be done when the DBA stores the common parameters in one file and references that common file in each instance by using the IFILE initialization parameter.

D: It can be not located in the default location for the primary instance's parameter file.

OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 227-230 Chapter 4: Performance and Scalability Enhancements

Oracle 9i New Features, Robert Freeman, p. 188-192 Chapter 7: Oracle9i Real Application Clusters