In which of the files below parameters are stored?

Options
- PFILE
- SPFILE
- PARFILE
- Both a and b


CORRECT ANSWER : Both a and b

Discussion Board
PFILE and SPFILE

Oracle provides two different types of parameter file: PFILE and SPFILE.
A PFILE (Parameter File) is a file that contains a list of initialization parameters and a value for each parameter. You specify initialization parameters in a parameter file that reflect your particular installation.
A SPFILE (Server Parameter File) is a binary file that acts as a repository for initialization parameters.

Prajakta Pandit 02-13-2017 02:09 AM

Write your comments


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)


Advertisement