What data can you compress using Advanced Compression in Oracle Database 11g?

The correct answer is B. Data that can be updated, inserted and/or deleted (DML). 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…

Advanced Concepts

Question

Options

ARead only data
BData that can be updated, inserted and/or deleted (DML)
COnly data being archived
DData warehousing data

How the community answered

(35 responses)

A
14% (5)
B
74% (26)
C
9% (3)
D
3% (1)

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).

Topics

#Advanced Compression#DML operations#Oracle 11g#compression types

Community Discussion

No community discussion yet for this question.

Full 1Z0-515 Practice