Database Design Quiz

What is the primary purpose of normalization in database design?

• To increase data redundancy

• To reduce data redundancy and dependency

• To complicate table structures

• To speed up data retrieval

Which normal form eliminates repeating groups?

• 2NF

• 3NF

• 1NF

• BCNF

What does functional dependency describe?

• The speed of data retrieval

• The relationship between attributes in a relational database

• The size of the database

• The security of the database

Ensuring that data remains the same across all instances and updates refers to:

• Data accuracy

• Data completeness

• Data consistency

• Data reliability

Which type of data integrity ensures that each row in a table is uniquely identifiable?

• Domain integrity

• Entity integrity

• Referential integrity

• User-defined integrity

What does referential integrity maintain?

• Data values within a defined range

• Business rules defined by users

• Consistency between related tables

• Protection from physical threats

Implementing checks to ensure that data meets predefined rules and formats is known as:

• Data backup

• Data auditing

• Data validation

• Data constraint

Which of the following is NOT a type of DBMS?

• RDBMS

• NoSQL

• SQL

• Hierarchical

What does RDBMS organize data into?

• Documents

• Graphs

• Tables

• Key-value pairs

What language is used to write queries in RDBMS?

• Java

• Python

• SQL

• C++