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.
Explanation:
https://docs.oracle.com/cd/B28359_01/server.111/b28286/statements_6016.htm#SQLRF01315
C
B
should be B
https://docs.oracle.com/cd/B28359_01/server.111/b28286/statements_6016.htm#SQLRF01315
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.