Home » Oracle » 1z0-485 » Which compression technique would you recommend?
If your customer wants to save storage space by compressing tables that are read frequently but rarely updated, which compression technique would you recommend?
A. OLTP
B. ARCHIVE HIGH
C. QUERY HIGH
D. ARCHIVE LOW
E. BASIC
Correct Answer: C
Explanation/Reference:
The clause "for query" compresses it in hybrid columnar manner. The clause "low" does not compress it as aggressively. So more space is consumed but compression and decompression do not consume as much CPU. A more aggressive compression can be achieved by replacing the "low" clause with "high". This type of HCC is known as warehouse compression since it is useful for data warehouses where a lot of data is stored but they are queried frequently.
|
Download Printable PDF. VALID exam to help you PASS.
|
 |
