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

2NF removes partial dependencies, ensuring every non-key attribute is fully dependent on the entire composite primary key.

Question 2

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

Accepted Answer

Atomicity, Consistency, Isolation, Durability

Answer

ACID stands for Atomicity, Consistency, Isolation, and Durability — the four properties that guarantee reliable database transactions.

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

A LEFT JOIN returns all rows from the left table and matched rows from the right table, filling NULLs where no match exists.

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

Indexes create a data structure that enables the database engine to locate rows faster, trading storage space for query performance.

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

Key-value stores like Redis are designed for ultra-fast access using a unique key to retrieve a value, making them ideal for caching and session storage.

Full-Stack Development Practice Test

Full-Stack Development Practice Test

Full-Stack Development Database Design & Management