The database stores a set of rows in an internal structure called a compression unit in case of Exadata Hybrid Columnar Compression.

  1. a. Compression unit can span across multiple data blocks

  2. b. The value of particular column can span across multiple blocks

  3. c. If a column in a compression unit is updated, the database will take a lock only on the updated rows

  4. d. If a column in a compression unit is updated, the database will take a lock on the entire compression unit


Correct Option: A,B,D

Find more quizzes: