4. Databases

Database Design — Quiz

Test your understanding of database design with 5 practice questions.

Practice Questions

Question 1

Which normal form requires that for every non-trivial functional dependency X→A, X is a superkey, thereby eliminating anomalies arising from dependencies between candidate key attributes?

Question 2

Which normal form specifically addresses the removal of multi-valued dependencies in a relation, ensuring that no relation contains two or more independent multi-valued facts about an entity?

Question 3

To evenly distribute rows of a large Orders table across multiple database nodes in a cluster and minimize data hotspots, which partitioning technique should be used?

Question 4

For a query filtering on both LastName and FirstName, which indexing strategy maximizes index utilization and minimizes I/O operations?

Question 5

What distinguishes a materialized view from a standard (virtual) view in a relational database?