Multiple choice

What Oracle backup and recover file contains user and system data?

  1. Control file

  2. Datafile

  3. OnLine ReDo file

  4. Offline ReDo file
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Datafiles are the Oracle files that contain actual user data and system data stored in tables, indexes, and other database segments. Control files (option A) contain metadata about the database structure but not the actual data. Online and offline redo log files (options C and D) contain transaction records for recovery purposes, not user or system data themselves. When users insert, update, or query data, they are interacting with data stored in datafiles.

Keep practicing — related questions