Multiple choice technology databases

Identify the physical component of the database, which stores the information about the database layout

  1. Datafile

  2. Controlfile

  3. Redolog Group

  4. Archivelogs

  5. Password File
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The control file is the physical component that stores metadata about the database structure, including datafile locations, tablespace details, checkpoint information, and the database layout itself. Datafiles store actual data, redolog groups store transactions for recovery, archivelogs are copies of redologs, and password files authenticate administrators.

Keep practicing — related questions