Horizontal vs vertical partitioning in HLD - Interactive Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to define horizontal partitioning as splitting data by {{BLANK_1}}.

HLD

Horizontal partitioning divides a database table into multiple tables where each table contains rows with [1] values.

Drag options to blanks, or click blank then click option'

Adifferent column

Bdifferent key

Cdifferent attribute

Ddifferent row

Attempts:

3 left

💡 Hint

Common Mistakes

Confusing rows with columns

Thinking horizontal means splitting columns

Horizontal partitioning splits data by rows, so each partition has different rows.

2fill in blank

medium

Complete the code to define vertical partitioning as splitting data by {{BLANK_1}}.

HLD

Vertical partitioning divides a database table into multiple tables where each table contains [1] of the original table.

Drag options to blanks, or click blank then click option'

Aindexes

Brows

Ccolumns

Dkeys

Attempts:

3 left

💡 Hint

Common Mistakes

Confusing columns with rows

Thinking vertical means splitting rows

Vertical partitioning splits data by columns, so each partition has different columns.

3fill in blank

hard

Fix the error in the statement about horizontal partitioning: 'It splits data by {{BLANK_1}}.'

HLD

Horizontal partitioning splits data by [1], not by columns.

Drag options to blanks, or click blank then click option'

Aindexes

Brows

Ccolumns

Dkeys

Attempts:

3 left

💡 Hint

Common Mistakes

Choosing columns instead of rows

Confusing partitioning types

Horizontal partitioning splits data by rows, not columns.

4fill in blank

hard

Fill both blanks to complete the sentence: 'Horizontal partitioning splits data by {{BLANK_1}}, while vertical partitioning splits data by {{BLANK_2}}.'

HLD

Horizontal partitioning splits data by [1], while vertical partitioning splits data by [2].

Drag options to blanks, or click blank then click option'

Arows

Bindexes

Ccolumns

Dkeys

Attempts:

3 left

💡 Hint

Common Mistakes

Mixing rows and columns

Choosing indexes or keys incorrectly

Horizontal partitioning splits by rows; vertical partitioning splits by columns.

5fill in blank

hard

Fill all three blanks to complete the dictionary comprehension for vertical partitioning: 'partitions = {{BLANK_1}}: {{BLANK_2}} for {{BLANK_3}} in table.columns if {{BLANK_2}} in selected_columns'

HLD

partitions = [1]: [2] for [3] in table.columns if [2] in selected_columns

Drag options to blanks, or click blank then click option'

Acolumn_name

Ccolumn

Drow

Attempts:

3 left

💡 Hint

Common Mistakes

Using rows instead of columns

Mixing variable names

This comprehension creates partitions by column names for vertical partitioning.