Exam 1z0-068 topic 1 question 123 discussion

Actual exam question from Oracle's 1z0-068

Question #: 123
Topic #: 1

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.

Show Suggested Answer

Suggested Answer: C 🗳️
Reference:
https://docs.oracle.com/cd/B28359_01/server.111/b28286/statements_6016.htm#SQLRF01315

by torynek at April 28, 2021, 4:52 p.m.