This test features data modeling questions to assess your skills in designing relational models, schemas, and database structures.

Free Data Modeling Test

In a relation where a non-candidate key determines another attribute, which normal form is violated?

A partial dependency exists in a composite primary key

Which of the following violates the Second Normal Form (2NF)?

Which of the following can uniquely identify each record in a table?

Which concurrency issue arises when two transactions read the same value, and both update based on the old value?

Which anomaly can still occur in the Repeatable Read isolation level?

What is the main purpose of normalization in databases?

Relationship to primary key in the same table

Relationship to primary key in another table

Which isolation level prevents dirty reads but allows non-repeatable reads?

A minimal set of attributes that can uniquely identify a tuple

Which of the following best describes a candidate key?

A non-prime attribute depends on another non-prime attribute

Which of the following is a violation of Third Normal Form (3NF)?

Super keys cannot contain extra attributes

Which of the following statements is TRUE about super keys and candidate keys?

Which ACID property ensures that once a transaction is completed, the changes are permanently saved?

A schedule with circular dependency in precedence graph

A schedule where reads and writes are ordered without conflict

Which of the following schedules is NOT conflict serializable?

If a transaction fails and the DB reverts to its original state, which ACID property is at work?