Multiple choice

What advantages does the server parameter file (SPFILE) provide when managing initialization parameters?

  1. The Oracle server maintains the server parameter file.

  2. The server parameter file is created automatically when the instance is started.

  3. Changes can be made in memory and/or in the SPFILE with the ALTER SYSTEM command.

  4. The use of SPFILE provides the ability to make changes persistent across shut down and start up.

  5. The Oracle server keeps the server parameter file and the text initialization parameter file synchronized.
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

The server parameter file (SPFILE) is a binary file maintained by the Oracle server, providing persistent storage and automatic synchronization of initialization parameters. While ALTER SYSTEM can update both memory and SPFILE, and changes persist across restarts, option A captures the core advantage - Oracle actively manages the SPFILE, preventing human edit errors and ensuring consistency.

Keep practicing — related questions