1Z0-485 · Question #2
Which two DML operations will add rows compressed by Hybrid Columnar Compression (HCC) to a table that is created to use HCC?
The correct answer is B. insert with an append hint D. CREATE TABLE AS SELECT. 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 Direct Path SQLLDR Create…
Question
Which two DML operations will add rows compressed by Hybrid Columnar Compression (HCC) to a table that is created to use HCC?
Options
- AINSERT
- Binsert with an append hint
- CUPDATE
- DCREATE TABLE AS SELECT
How the community answered
(22 responses)- A14% (3)
- B77% (17)
- C9% (2)
Explanation
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 * Direct Path SQL*LDR * Create Table as Select (CTAS) 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
Topics
Community Discussion
No community discussion yet for this question.