Question 1

What is normalization in relational database?

Accepted Answer

Organizing data to minimize redundancy and dependency.

Answer

Randomly arranging data without any specific structure.

Answer

Storing data in a single table without any relationship.

Answer

Duplicating data in multiple tables for easier access.

Question 2

What is a primary key in a relational database?

Accepted Answer

A unique identifier for each record in a table.

Answer

A field that contains multiple values for each record.

Answer

A table that stores the metadata of the database.

Answer

A query used to combine data from multiple tables.

Question 3

What is the purpose of database normalization?

Accepted Answer

To eliminate data redundancy and increase data integrity.

Answer

To store data in a single table without any organization.

Answer

To increase data redundancy and improve performance.

Answer

To randomly arrange data in a database.

Question 4

What is the First Normal Form (1NF)?

Accepted Answer

Ensuring atomicity of data by eliminating repeating groups.

Answer

Combining multiple tables into a single table for increased performance.

Answer

Breaking a single table into multiple tables for better organization.

Answer

Removing all relationships between tables for easier management.

Question 5

What is the purpose of foreign keys in a relational database?

Accepted Answer

To establish relationships between tables.

Answer

To store data in a single table.

Answer

To combine data from multiple tables.

Answer

To create duplicate entries in a table.

Question 6

What is the Second Normal Form (2NF) in database normalization?

Accepted Answer

Ensuring non-key attributes depend on the entire primary key.

Answer

Combining multiple tables into a single table for increased performance.

Answer

Removing all relationships between tables for easier management.

Answer

Breaking a single table into multiple tables for better organization.

Question 7

What is the Third Normal Form (3NF) in database normalization?

Accepted Answer

Ensuring non-key attributes do not depend on other non-key attributes.

Answer

Removing all relationships between tables for easier management.

Answer

Breaking a single table into multiple tables for better organization.

Answer

Combining multiple tables into a single table for increased performance.

Question 8

What is a composite key in a relational database?

Accepted Answer

A key that consists of two or more columns.

Answer

A single column used as a primary key.

Answer

A unique identifier for each record in a table.

Answer

A foreign key referencing another table.

Question 9

What is the purpose of referential integrity in a relational database?

Accepted Answer

To maintain consistency and relationships between related tables.

Answer

To randomly arrange data in a database for increased performance.

Answer

To store data in a single table without any organization.

Answer

To eliminate data redundancy and increase data integrity.

Related quizzes