Oracle Database Administration I — Question 159

Which three statements are true about an SPFILE? (Choose three.)

Answer options

• A. It must exist for a database instance to start.
• B. It can be used to create a pfile.
• C. It contains initialization parameters whose values can be changed using the ALTER SYSTEM command.
• D. It can be created by SYS from an idle instance.
• E. It contains only static initialization parameters.

Correct answer: B, C, D

Explanation

The correct answers are B, C, and D because an SPFILE can indeed be used to create a pfile (B), it allows for the modification of initialization parameters via the ALTER SYSTEM command (C), and it can be created by SYS from an idle instance (D). Option A is incorrect because while an SPFILE is beneficial, a database instance can start with a PFILE. Option E is also incorrect since an SPFILE can contain both static and dynamic parameters.