Your X6 Exadata Database Machine is running Oracle Database 12c, and has a large database with some very
large tables supporting OLTP workloads.
High-volume insert applications and high-volume update workloads access the same tables.You wish to compress these tables without causing unacceptable performance overheads to the OLTP
workload.
Which three are true regarding this requirement?
A.
Compression is performed on database servers when using row store compress advanced in an Exadata
environment.
B.
Using row store compress advanced will compress the data more than if using column store compress for
archieve low.
C.
The compression method column store compress for archive high is the worst fit for this requirement.
D.
Compression is performed on Exadata Storage Servers when using row store compress advanced in an
Exadata environment.
E.
Using row store compress advanced will compress the data less than if using column store compress for
query low.
Explanation:
A: Creating a Table with Advanced Row Compression
The following example enables advanced row compression on the table orders:
CREATE TABLE orders … ROW STORE COMPRESS ADVANCED;
B: ARCHIVE LOW compression (Exadata only), recommended for Archival Data with Load Time as a critical factor
Incorrect Answers:
E: QUERY LOW compression (Exadata only), recommended for Data Warehouse with Load Time as a critical factor.
References: https://docs.oracle.com/database/121/ADMIN/tables.htm#ADMIN015
https://uhesse.com/2011/01/21/exadata-part-iii-compression/