Oracle Exam 1Z0-070 Topic 7 Question 20 Discussion

Actual exam question for Oracle's 1Z0-070 exam

Question #: 20
Topic #: 7

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?

ACompression is performed on database servers when using row store compress advanced in an Exadata environment.

BUsing row store compress advanced will compress the data more than if using column store compress for archive low.

CThe compression method column store compress for archive high is the worst fit for this requirement.

DCompression is performed on Exadata Storage Servers when using row store compress advanced in an Exadata environment.

EUsing row store compress advanced will compress the data less than if using column store compress for query low.

Show Suggested Answer

Suggested Answer: A, B, D

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

by Pamella at May 08, 2022, 01:03 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!