Oracle Database 12c: Installation and Administration — Question 81

Which three statements are true PFILEs, SPFILEs or both? (Choose three.)

Answer options

• A. SPFILEs and PFILEs may both be edited with an O/S editing utility
• B. Some SPFILE parameters can be modified successfully with the SCOPE=MEMORY clause
• C. A SPFILE can be created by an idle instance
• D. A PFILE can be created by an idle instance
• E. All SPFILE parameters can be modified successfully with the SCOPE=BOTH clause
• F. All SPFILE parameters can be modified successfully with the SCOPE=MEMORY clause

Correct answer: B, C, D

Explanation

Option B is correct because some SPFILE parameters can indeed be modified with the SCOPE=MEMORY clause, which means the changes only apply to the current instance. Option C is accurate since a SPFILE can be created without an active instance, and option D is also true as a PFILE can be generated by an idle instance. Options A, E, and F are incorrect as not all SPFILEs can be edited with O/S utilities and not every parameter can be modified with the specified SCOPE options.