Multiple choice technology programming languages

The main difference between a pfile and spfile in Oracle is

  1. pfile is a binary file

  2. spfile is a binary file

  3. spfile is a text file

  4. pfile is a binary file ; spfile is a text file
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

SPFILE (Server Parameter File) is a binary file stored on the server that enables persistent parameter changes. PFILE (Parameter File) is a text-based initialization file. The binary nature of SPFILE allows Oracle to read it more efficiently and make changes that survive restarts.

Keep practicing — related questions