Multiple choice technology databases

What is true about “Parallel Backups” in Oracle 11g? Choose all that apply

  1. If the datafile resides on only one disk, there is no advantage of using parallel backups

  2. The size of all the sections of a datafile involved in “Parallel backup” are always same

  3. The size of all the sections of a datafile involved in “Parallel backup” are always same except the size of the last section

  4. All the sections of one datafile are backed up by the same channel

  5. All the sections of one datafile are backed up by different channels
Reveal answer Fill a bubble to check yourself
A,C,E Correct answer
Explanation

Parallel backups in RMAN divide datafiles into sections backed up by multiple channels simultaneously. Option A is correct because single-disk systems see no performance benefit from parallelism. Option C is correct because RMAN creates equal-sized sections except the last one. Option E is correct because each channel handles different sections. Options B and D are incorrect because sections aren't always same size and aren't backed up by same channel.

Keep practicing — related questions