Full-Stack Development Database Design & Management

Question 1

Which normal form eliminates partial dependencies on a composite primary key?

Accepted Answer

Second Normal Form (2NF)

Answer

First Normal Form (1NF)

Answer

Third Normal Form (3NF)

Answer

Boyce-Codd Normal Form (BCNF)

Question 2

In a relational database, what does the ACID acronym stand for?

Accepted Answer

Atomicity, Consistency, Isolation, Durability

Answer

Accuracy, Completeness, Integrity, Distribution

Answer

Atomicity, Concurrency, Integrity, Durability

Answer

Accuracy, Consistency, Isolation, Dependency

Question 3

Which SQL JOIN type returns all rows from the left table even if there is no match in the right table?

Accepted Answer

LEFT JOIN

Answer

INNER JOIN

Answer

RIGHT JOIN

Answer

FULL OUTER JOIN

Question 4

What is the purpose of a database index?

Accepted Answer

To speed up data retrieval operations at the cost of additional storage

Answer

To enforce referential integrity between tables

Answer

To automatically backup table data

Answer

To encrypt sensitive columns

Question 5

Which NoSQL database type is best suited for storing data as key-value pairs with very fast read/write performance?

Accepted Answer

Key-value store (e.g., Redis)

Answer

Document store (e.g., MongoDB)

Answer

Column-family store (e.g., Cassandra)

Answer

Graph database (e.g., Neo4j)

Question 6

What SQL clause is used to filter results after a GROUP BY aggregation?

Accepted Answer

HAVING

Answer

WHERE

Answer

FILTER

Answer

LIMIT

Question 7

In database design, what is a foreign key?

Accepted Answer

A column that references the primary key of another table

Answer

A key that uniquely identifies each row in a table

Answer

An encrypted version of the primary key

Answer

A composite key made from multiple columns