Database Administration2081.110 marksSpfile versus Pfile differentiation
What is initialization parameter file? Differentiate between Spfile and Pfile. Explain some oracle defined roles with suitable example.
What is initialization parameter file? Differentiate between Spfile and Pfile. Explain some oracle defined roles with suitable example.[10]
Note: The reference notes did not contain material on this topic. The following answer is based on standard Oracle Database concepts as taught in BSc CSIT Database Administration courses. --- An Initialization Parameter File (also called an init file) is a configuration file used by Oracle Databa...