What data can you compress using Advanced Compression in Oracle Database 11g?
A.
Read only data
B.
Data that can be updated, inserted and/or deleted (DML)
C.
Only data being archived
D.
Data warehousing data
Explanation:
Oracle Database 11g has new option named as Oracle Advanced Table
Compression option which aims at reducing space occupied by data for both OLTP and
warehouse databases. This option provides the following types of compression:
* Compression of data tables even for OLTP environment. (Previous versions had compression
option for tables that are mostly read only).
* Compression of unstructured data in SecureFiles.
* Compression of RMAN backups.
* Compression in Data Pump Export files.
* Compression of redo data transmitted to a standby database during redo gap resolution (when
data guard is configured).
What’s wrong with D?
B and D,
D Describes better read only data, and archived data, Data warehousing
B, DML OPerations can be done in compressed data (OLTP).