Database management system

1. What is the primary goal of database design?

a) To store data efficiently b) To ensure data integrity c) To optimize query performance d) All of the above

2. Which of the following is a key principle of relational database design?

a) Data redundancy b) Data normalization c) Data duplication d) Data inconsistency

3. What is an integrity constraint in a database?

a) A rule that ensures data accuracy and consistency b) A rule that allows duplicate data c) A rule that increases data redundancy d) A rule that slows down query performance

4. Which of the following is an example of an integrity constraint?

a) Primary Key b) Foreign Key c) Unique Constraint d) All of the above

5. What is the purpose of normalization in database design?

a) To reduce data redundancy b) To improve data integrity c) To simplify database structure d) All of the above

6. Which normal form is also known as Boyce-Codd Normal Form (BCNF)?

a) 1NF b) 2NF c) 3NF d) 4NF

7. What is the main condition for a table to be in BCNF?

a) Every determinant must be a candidate key b) The table must be in 3NF c) There should be no partial dependencies d) All of the above

8. Which of the following is a design guideline for relational databases?

a) Avoid data redundancy b) Use primary keys to uniquely identify records c) Normalize the database to reduce anomalies d) All of the above

9. What is a candidate key in a database?

a) A unique identifier for a record b) A key that can be used as a primary key c) A minimal superkey d) All of the above

10. What is the difference between a primary key and a unique key?

a) A primary key cannot have NULL values, but a unique key can b) A primary key is used to enforce entity integrity c) A unique key ensures that all values in a column are unique d) All of the above

11. What is a foreign key in a database?

a) A key used to link two tables b) A key that references the primary key of another table c) A key that ensures referential integrity d) All of the above

12. What is the purpose of referential integrity in a database?

a) To ensure that relationships between tables remain consistent b) To prevent orphan records c) To enforce foreign key constraints d) All of the above

13. What is a superkey in a database?

a) A set of attributes that can uniquely identify a record b) A key that includes more attributes than necessary c) A candidate key d) All of the above

14. What is the main advantage of using BCNF in database design?

a) It eliminates data redundancy b) It ensures data integrity c) It simplifies database maintenance d) All of the above

15. What is a partial dependency in database normalization?

a) When a non-prime attribute depends on part of a candidate key b) When a non-prime attribute depends on the entire candidate key c) When a prime attribute depends on a non-prime attribute d) None of the above

Database Design MCQs

Your Score: /15