Data Engineer Interview Questions and Answers
Question: What is the difference between horizontal and vertical partitioning in database design?Answer: Horizontal partitioning divides a table into smaller tables with the same columns but different rows, while vertical partitioning divides a table into smaller tables with fewer columns but the same rows.Example:
|
Save For Revision
Bookmark this item, mark it difficult, or place it in a revision set.
Log in to save bookmarks, difficult questions, and revision sets.
Is it helpful? Yes No
Most helpful rated by users:
- What is a schema in the context of databases?
- Explain the concept of ETL in the context of data engineering.