Multiple choice

Which physical file contains the name and location of datafiles?

  1. Redo log file

  2. Paramerter File

  3. Password File

  4. Control File

Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

The control file is a small binary file that contains critical metadata about the database structure, including the names, locations, and status of all datafiles. Oracle reads the control file at startup to locate and open all datafiles. Redo logs contain transaction changes, parameter files have initialization settings, and password files store authentication data.

Keep practicing — related questions