Oracle Database 12c: Multitenancy Essentials — Question 9

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?

Answer options

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

Correct answer: A, B, D

Explanation

The correct answers are A, B, and D because compression in an Exadata environment can take place on database servers for row store compress advanced and on Exadata Storage Servers, providing effective performance for OLTP workloads. Option C is incorrect as column store compress for archive high is not the optimal choice for high-volume OLTP operations. Option E is also wrong since row store compress advanced typically achieves better compression than column store compress for query low.