Multiple choice technology databases

Which file can be multiplexed?

  1. parameter file

  2. data files

  3. redo log files

  4. alert.log file

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

In Oracle databases, redo log files can be multiplexed - meaning multiple copies of the same redo log group can be maintained simultaneously on different disks to protect against disk failure. The parameter file (spfile or pfile) is a single configuration file. Data files cannot be multiplexed - they are the actual storage for database data. The alert.log is a single text file that records database events and cannot be multiplexed.