Question 1

True or false: PostgreSQL was originally developed by a team at Microsoft.

Accepted Answer

False. It was created at the University of California, Berkeley under the name Postgres. Microsoft had no involvement.

Question 2

True or false: You can create recursive queries in PostgreSQL using WITH RECURSIVE.

Accepted Answer

True. PostgreSQL supports Common Table Expressions (CTEs) with recursion, great for tree or graph traversal queries.

Question 3

True or false: PostgreSQL allows you to define custom data types using CREATE TYPE.

Accepted Answer

True. You can create composite, enumerated, or range types, and even define operators for them. Highly extensible.

Question 4

True or false: PostgreSQL cannot run stored procedures, only functions.

Accepted Answer

False. Since PostgreSQL 11, it supports stored procedures with transaction control, separate from functions.

Question 5

True or false: PostgreSQL does not support full-text search out of the box.

Accepted Answer

False. It actually includes powerful built-in full-text search with tsvector and tsquery, no extensions needed.

Question 6

True or false: PostgreSQL can act as a vector database for AI applications using the pgvector extension.

Accepted Answer

True. The pgvector extension enables storing and querying vector embeddings, making PostgreSQL suitable for AI and semantic search.

Question 7

True or false: PostgreSQL can query JSON data more efficiently than MongoDB in some cases.

Accepted Answer

True. PostgreSQL's native binary JSONB format supports indexing and complex queries, often outperforming MongoDB on analytical JSON workloads.

Question 8

True or false: PostgreSQL only supports row-level locking, not page-level locking.

Accepted Answer

False. It supports multiple locking levels, including row-level, page-level, and table-level locks for concurrency control.

PostgreSQL Trivia Questions