ExamTopics Logo
Mail Us[email protected]
Menu
Oracle Discussions
exam questions

Exam 1z0-485 All Questions

View all questions & answers for the 1z0-485 exam
Go to Exam

Exam 1z0-485 topic 1 question 14 discussion

Actual exam question from Oracle's 1z0-485
Question #: 14
Topic #: 1
[All 1z0-485 Questions]

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
Show Suggested Answer Hide Answer
Suggested Answer: BD 🗳️
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.
by [deleted] at April 4, 2025, 8:15 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
Currently there are no comments in this discussion, be the first to comment!
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel