Multiple choice technology databases

What are the advantages of column-oriented architecture over traditional row-oriented architecture? (Choose 3)

  1. Better data compression

  2. Less I/O

  3. Faster performance for decision support queries that involve only a few columns

  4. Best suited for OLTP
Reveal answer Fill a bubble to check yourself
A,B,C Correct answer
Explanation

Column-oriented storage enables better compression (similar values in a column compress well), reduces I/O (only needed columns are read), and accelerates decision-support queries that access few columns. OLTP is NOT well-suited - it requires row-oriented access for transactional updates. This is a key architectural difference.

Keep practicing — related questions