Node.js Database Integration 4

Question 1

What does `client.release()` do in the `pg` pool API?

Accepted Answer

Returns the client back to the pool for reuse

Answer

Calling `release()` signals that the client is done and can be reused by the pool for future queries.

Question 2

In Prisma, how do you run a raw SQL query?

Accepted Answer

prisma.$queryRaw`SELECT ...`

Answer

`prisma.$queryRaw` uses a tagged template literal to safely execute raw SQL and return typed results.

Question 3

Which Sequelize method fetches a single record by its primary key?

Accepted Answer

Model.findByPk(id)

Answer

`findByPk` is a shortcut that queries by primary key, equivalent to `findOne({ where: { id } })` but more explicit.

Question 4

What is the default behavior of Mongoose's `find()` when no documents match the query?

Accepted Answer

Resolves with an empty array []

Answer

`find()` always resolves with an array; an empty array `[]` means no matches were found.

Question 5

In a SQLite database accessed via `better-sqlite3` in Node.js, what makes it different from most other Node.js DB drivers?

Accepted Answer

It is synchronous — queries block the event loop

Answer

`better-sqlite3` exposes a synchronous API intentionally, unlike async drivers, which simplifies code but blocks the event loop.

Node.js Practice Test