Q: Which type of database storage structure is optimized for column-wise data storage?

A Row-oriented
B Conventional
C Column-oriented
D Index-based

Share this MCQ

Answer: C

Explanation:

Column-oriented database storage structures are optimized for column-wise data storage.
Instead of storing data row by row, they store data column by column.
This structure is beneficial for analytical workloads that involve aggregations, data compression, and selective column retrieval.

Database Concepts MCQs

Share Above MCQ

‹ Previous Next ›

Write your comment

Learn More MCQ Questions from DataBase Management System Database Concepts MCQs

Q: Which type of database storage structure is optimized for column-wise data storage?

Report Question