Free Test Relational Database De... – Databas...

Q1: What is the primary goal of relational database design?

A. To minimize redundancy and avoid anomalies B. To maximize redundancy C. To create as many tables as possible D. To store data without constraints

Q2: What is a functional dependency?

A. A relationship where one attribute uniquely determines another B. Dependency between tables C. Dependency on keys only D. No dependency

Q3: Which normal form requires that all attributes be functionally dependent on the primary key?

A. 1NF B. 2NF C. 3NF D. BCNF

Q4: What does 1NF (First Normal Form) require?

A. Atomic values in columns and no repeating groups B. No transitive dependency C. No partial dependency D. Only key attributes

Q5: What problem does normalization solve?

A. Data redundancy and update anomalies B. Slow query performance C. Security issues D. Backup failure

Q6: Which normal form removes transitive dependency?

A. 3NF B. 2NF C. 1NF D. BCNF

Q7: What is transitive dependency?

A. When attribute A determines B, and B determines C B. When attribute A determines B only C. When there is no dependency D. When multiple keys exist

Q8: What is Boyce-Codd Normal Form (BCNF)?

A. A stronger version of 3NF where every determinant is a candidate key B. A weaker form of 3NF C. Same as 2NF D. No dependencies

Q9: Which of these is a characteristic of 2NF?

A. No partial dependency on a subset of primary key B. No transitive dependency C. Atomic values only D. No foreign keys

Q10: What is a candidate key?

A. An attribute or set of attributes that uniquely identifies a row B. Primary key only C. Foreign key D. Any attribute

Q11: What is a primary key?

A. A candidate key chosen to uniquely identify tuples B. Any key C. Foreign key D. Composite key only

Q12: What is a foreign key?

A. An attribute that refers to primary key in another table B. A key unique within a table C. A composite key D. An index

Q13: What is a composite key?

A. A key made of multiple attributes B. A key with a single attribute C. A foreign key D. A surrogate key

Q14: Why is denormalization used?

A. To improve query performance at the cost of redundancy B. To reduce redundancy C. To enforce data integrity D. To simplify schema

Q15: Which anomaly is caused by insertion of incomplete data?

A. Insertion anomaly B. Deletion anomaly C. Update anomaly D. Referential anomaly

Q16: What does the update anomaly cause?

A. Inconsistent data after update B. Failure to insert data C. Loss of data after delete D. Duplicate data

Q17: What is the deletion anomaly?

A. Loss of data unintentionally when deleting other data B. Duplication of data C. Failure to delete data D. None of the above

Q18: Which of the following is NOT a normal form?

A. 5NF B. 4NF C. 6NF D. 7NF

Q19: Which normal form handles multi-valued dependencies?

A. 4NF B. 3NF C. BCNF D. 2NF

Q20: What is a surrogate key?

A. A system-generated key to uniquely identify a row B. A natural key C. A foreign key D. A composite key

Quiz for Relational Database Design