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?
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: B
Specify MEMORY to create an spfile using the current system-wide parameter settings. In a RAC environment, the created file will contain the contain the parameter settings from each instance.
B correct
Tested – only one spfile is created on server where command is executed. Such spfile contains parameters common for all instances (*. prefix) as well as parameter specific to each instance.