nerdexam
Oracle

1Z0-083 · Question #166

Which two are true about backup set compression using RMAN default compression? (Choose two.)

The correct answer is B. Binary compression adds CPU overhead to backup operations. E. Compression can be done only for locally managed tablespaces. Backup as compressed backupset device type disk database section size 100m; (not A, not D). If they speak about Unused block compression then : RMAN skips reading, and backing up, any database blocks that are not currently allocated to some database object. This is regardless…

Perform Advanced RMAN Concepts

Question

Which two are true about backup set compression using RMAN default compression? (Choose two.)

Options

  • ACompressed backups can be written only to media.
  • BBinary compression adds CPU overhead to backup operations.
  • CUnused blocks below the high water mark are backed up.
  • DCompressed backups cannot have a section size defined.
  • ECompression can be done only for locally managed tablespaces.

How the community answered

(27 responses)
  • A
    7% (2)
  • B
    78% (21)
  • C
    11% (3)
  • D
    4% (1)

Explanation

Backup as compressed backupset device type disk database section size 100m; (not A, not D). If they speak about Unused block compression then : RMAN skips reading, and backing up, any database blocks that are not currently allocated to some database object. This is regardless of whether those blocks had previously been allocated (bellow HWM). (Not C) Data file has to be locally managed. (E)

Topics

#RMAN compression#backup sets#binary compression#CPU overhead

Community Discussion

No community discussion yet for this question.

Full 1Z0-083 Practice