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?

Question

Options

• AAn SPFILE is created and contains parameter settings only for PROD1.
• BAn SPFILE is created and contains parameter settings for all instances.
• CAn SPFILE is created for each instance containing instance-specific parameter settings only.
• DAn SPFILE is created for each instance and contains parameter settings for all instances.

• A
  6% (2)
• B
  3% (1)
• C
  79% (27)
• D
  12% (4)

No community discussion yet for this question.