Oracle Database 12c: RAC Administration — Question 43

You are administering an ORACLE RAC database with multiple instances.
Examine this command executed from the PROD1 instance which succeeds:
CREATE SPFILE FROM MEMORY;
Which statement is true?

Answer options

• A. An SPFILE is created and contains parameter settings only for PROD1.
• B. An SPFILE is created and contains parameter settings for all instances.
• C. An SPFILE is created for each instance containing instance-specific parameter settings only.
• D. An SPFILE is created for each instance and contains parameter settings for all instances.

Correct answer: C

Explanation

The correct answer is C because the command creates an SPFILE for each instance that holds only the parameters that are specific to that instance. Options A and B are incorrect as they do not accurately capture the nature of the SPFILE in a multi-instance environment, while option D incorrectly states that all instances' parameters are included in each instance's SPFILE.