Multiple choice technology databases

When tables use Exadata Hybrid Columnar Compression, Oracle DML locks larger blocks of data (compression unit) which might reduce concurrency

  1. a. For basic and online archival compression inserted and updated rows are uncompressed

  2. b. Higher compression levels of Exadata Hybrid Columnar Compression are achieved only with data that is direct-path inserted

  3. c. High CPU overhead in case Warehouse compression

  4. d. Conventional inserts and updates are supported in Exadata Hybrid Columnar Compression but the extent of compression is low
Reveal answer Fill a bubble to check yourself
A,B,C,D Correct answer
Explanation

Exadata Hybrid Columnar Compression (EHCC) stores data in compression units, which are larger blocks that Oracle locks during DML operations, potentially reducing concurrency. Basic compression leaves inserted/updated rows uncompressed until they are moved during maintenance operations. Higher compression levels (Archive) require direct-path insert operations to achieve maximum compression ratios. Conventional DML is supported but results in lower compression efficiency, while warehouse compression can incur higher CPU overhead during compression and decompression operations.

Keep practicing — related questions