Oracle Database 12c: Advanced Administration — Question 78

You issue the RMAN command:
RMAN> BACKUP SECTION SIZE 300M TABLESPACE users;
Which statement is true about the execution of the command?

Answer options

• A. The resulting backupset has backup pieces that cannot exceed 300 MB.
• B. RMAN uses multiplexing to perform the backup.
• C. RMAN always performs this type of backup in parallel.
• D. The backup succeeds only if the USERS tablespace is locally managed.
• E. The backup set size is limited to 300 MB.

Correct answer: C

Explanation

The correct answer is C because RMAN performs the backup in parallel when the SECTION SIZE is specified, optimizing the process. Options A and E are misleading as they imply a restriction on the entire backup set rather than individual pieces. Option B incorrectly suggests that multiplexing is utilized, which is not guaranteed with this command. Option D is irrelevant since the command does not specifically require the USERS tablespace to be locally managed.