Multiple choice technology databases

Which of the following is applicable for Exadata Hybrid Columnar Compression?

  1. a. The database stores the same column for a group of rows together

  2. b. The data block does not store the rows in the row-major format

  3. c. The database stores the identical rows together with a reference for each row

  4. d. Database operations works transparently against compressed objects without the need of changing application code
Reveal answer Fill a bubble to check yourself
A,B,D Correct answer
Explanation

EHCC stores column data for a group of rows together instead of using traditional row-major formatting, allowing database operations to execute fully transparently against compressed objects. It does not store identical rows with references, which makes option c incorrect. Therefore, options a, b, and d are correct.

Keep practicing — related questions