Home » Oracle » 1z0-485 » Which two DML operations will add rows compressed by Hybrid Columnar Compression (HCC) to a table that is created to use HCC?
Which two DML operations will add rows compressed by Hybrid Columnar Compression (HCC) to a table that is created to use HCC?
A. INSERT
B. insert with an append hint
C. UPDATE
D. CREATE TABLE AS SELECT
Correct Answer: BD
Explanation/Reference:
To maximize storage savings with Hybrid Columnar Compression, data must be loaded using data warehouse bulk loading techniques. Examples of bulk load operations commonly used in data warehouse environments are:
* Insert statements with the APPEND hint
* Parallel DML
* Direct Path SQL*LDR
* Create Table as Select (CTAS)
Incorrect:
Not A, Not C: DML operations (INSERT/UPDATE) against a Hybrid Columnar Compressed table/partition can reduce the overall compression savings over time since data INSERTED/UPDATED via DML operations will not be compressed to the same ratio as data that is bulk loaded.
Download Printable PDF. VALID exam to help you PASS.
|
|