Full-Stack Development Database Design & Management 2

Question 1

What is an ORM (Object-Relational Mapper) used for in full-stack development?

Accepted Answer

Mapping database tables to programming language objects to simplify data access

Answer

An ORM abstracts database interactions by mapping tables to classes and rows to objects, allowing developers to query databases using their programming language instead of raw SQL.

Question 2

Which PostgreSQL feature allows you to store and query JSON data natively?

Accepted Answer

JSONB column type

Answer

PostgreSQL's JSONB type stores JSON in a binary format that supports indexing and efficient querying, making it ideal for semi-structured data.

Question 3

What is database sharding?

Accepted Answer

Horizontally partitioning data across multiple database instances

Answer

Sharding splits a large database horizontally across multiple servers (shards), each holding a subset of the data, to improve scalability and performance.

Question 4

In a relational database, what does a composite primary key consist of?

Accepted Answer

Two or more columns whose combined values uniquely identify a row

Answer

A composite primary key uses multiple columns together to uniquely identify each row, commonly used in junction tables representing many-to-many relationships.

Question 5

What is the primary difference between a clustered and a non-clustered index?

Accepted Answer

A clustered index determines the physical order of data in the table; non-clustered does not

Answer

A clustered index physically reorders table rows to match the index order, while a non-clustered index is a separate structure that points to the actual row data.

Full-Stack Development Practice Test

Full-Stack Development Practice Test

Full-Stack Development Database Design & Management 2