Quiz

Database Fundamentals

0% completed

Quiz

Question 1

What does the term "sharding" refer to in distributed databases?

A

Splitting data vertically across multiple tables

B

Replicating the entire database to multiple nodes

C

Dividing a database into smaller pieces stored on different nodes

D

Compressing data to save space

Question 2

In horizontal partitioning, how is data divided?

A

By splitting rows into multiple subsets

B

By splitting columns into smaller tables

C

By duplicating entire tables across nodes

D

By hashing rows into fixed ranges

Question 3

What happens in range partitioning?

A

Data is divided based on a fixed hash function

B

Data is assigned cyclically to partitions

C

Data is copied entirely across all nodes

D

Data is divided into continuous intervals based on a key

Question 5

Which technique in distributed databases minimizes data transfer during query execution?

A

Push-Down Predicates

B

Hash Partitioning

C

Range Partitioning

D

Query Rebalancing

Question 5

What is the primary goal of distributed query processing?

A

Minimize the number of transactions in the database

B

Ensure that all queries are executed sequentially

C

Retrieve data efficiently from multiple nodes with minimal latency

D

Enforce strict database constraints

Question 6

What is a key difference between horizontal partitioning and sharding?

A

Horizontal partitioning is used within a single database, while sharding involves multiple nodes

B

Horizontal partitioning is always based on hashing

C

Sharding always involves data compression

D

Horizontal partitioning ensures high availability

.....

Like the course? Get enrolled and start learning!