Interview Questions for MongoDB,
PostgreSQL, and Hibernate
This document contains a comprehensive set of interview questions covering MongoDB,
PostgreSQL, and Hibernate. Each question is explained with clear, concise, and detailed
concepts.
MongoDB Interview Questions
Basics
What is MongoDB and how is it different from traditional relational databases?
MongoDB is a NoSQL database that stores data in a flexible JSON-like format called BSON
(Binary JSON). Unlike relational databases that use structured tables and rows, MongoDB
allows for a more dynamic schema, meaning you can have different fields in different
documents within the same collection.
What are BSON and its advantages?
BSON (Binary JSON) is a format used to represent data in MongoDB. It supports more data
types than JSON, such as dates and binary data. Its advantages include efficient data storage
and faster data retrieval due to its binary nature.
What is a collection in MongoDB?
A collection in MongoDB is similar to a table in relational databases. It is a group of related
documents stored in the database. Each document in a collection can have different fields
and structures.
How do you define a schema in MongoDB?
In MongoDB, schemas are not strictly enforced, but you can define one using Mongoose (a
library for MongoDB) or by following conventions. You can set rules about the data types
and required fields to help maintain data consistency.
What is a document in MongoDB?
A document is a basic unit of data in MongoDB represented in BSON format. It is similar to a
row in a relational database and can contain various fields and values.
CRUD Operations
How do you insert a document into a MongoDB collection?
You can insert a document using the insertOne() or insertMany() methods. Example:
db.collectionName.insertOne({ name: "John", age: 30 });
What is the difference between insertOne() and insertMany()?
insertOne() is used to insert a single document, while insertMany() is used to insert
multiple documents at once. Example:
db.collectionName.insertMany([{ name: "Jane" }, { name: "Doe" }]);
How do you update a document in MongoDB?
You can update documents using the updateOne() or updateMany() methods. Example:
db.collectionName.updateOne({ name: "John" }, { $set: { age: 31 } });
What is the difference between update() and save()?
update() modifies existing documents based on a query, while save() is used to either insert
a new document or update an existing one. If the document already exists, save() updates it;
if not, it creates a new one.
How do you delete a document in MongoDB?
You can delete a document using deleteOne() or deleteMany() methods. Example:
db.collectionName.deleteOne({ name: "John" });
Querying Data
How do you retrieve a single document from a collection?
You can use the findOne() method to retrieve a single document. Example:
db.collectionName.findOne({ name: "Jane" });
What are query operators in MongoDB?
Query operators are special keywords used to specify conditions in your queries. Examples
include $eq (equal), $gt (greater than), $lt (less than), and $in (matches any value in an
array).
How do you perform a case-insensitive search?
You can perform a case-insensitive search using a regular expression. Example:
db.collectionName.find({ name: { $regex: /^john$/i } });
What is the purpose of the $exists operator?
The $exists operator checks if a specific field exists in a document. Example:
db.collectionName.find({ age: { $exists: true } });
Explain how to use the $or and $and operators in queries.
The $or operator allows you to specify multiple conditions where at least one must be true,
while $and requires all conditions to be true. Example:
db.collectionName.find({ $or: [{ age: { $lt: 25 } }, { name: "John" }] });
PostgreSQL Interview Questions
Basics
What is PostgreSQL and what are its key features?
PostgreSQL is an open-source relational database management system known for its
advanced features like support for complex queries, full-text search, and extensibility
through custom data types and functions. It emphasizes standards compliance and data
integrity.
What is a database schema?
A database schema is the structure that defines how data is organized in the database,
including tables, fields, relationships, and constraints. It acts like a blueprint for the
database.
What is a table in PostgreSQL?
A table is a collection of rows and columns that stores data in a relational database. Each
column has a specific data type and each row represents a record.
How does PostgreSQL handle data types?
PostgreSQL supports a wide range of data types including integers, strings, dates, and
custom types. You can choose the appropriate type based on the data you are storing,
ensuring data integrity.
What are the advantages of using PostgreSQL over other databases?
Advantages include strong data integrity through ACID compliance, support for advanced
data types (e.g., JSON, arrays), powerful indexing capabilities, and support for complex
queries and stored procedures.
CRUD Operations
How do you create a table in PostgreSQL?
You can create a table using the CREATE TABLE statement. Example:
CREATE TABLE users (
id SERIAL PRIMARY KEY,
name VARCHAR(100),
age INT
);
What is the SERIAL data type and how is it used?
The SERIAL data type is a special type in PostgreSQL that automatically generates a unique
integer for each new record. It is often used for primary key fields.
How do you perform an INSERT operation in PostgreSQL?
You can insert data into a table using the INSERT INTO statement. Example:
INSERT INTO users (name, age) VALUES ('Alice', 30);
What is the difference between UPDATE and UPSERT?
UPDATE modifies existing records in a table, while UPSERT (a combination of insert and
update) inserts a new record if it doesn't exist or updates it if it does. In PostgreSQL, you can
perform an UPSERT using the INSERT ... ON CONFLICT statement.
How do you delete records from a table in PostgreSQL?
You can delete records using the DELETE statement. Example:
DELETE FROM users WHERE name = 'Alice';
Querying Data
How do you retrieve data from a PostgreSQL table?
You can retrieve data using the SELECT statement. Example:
SELECT * FROM users;
What are the different types of joins available in PostgreSQL?
PostgreSQL supports several types of joins including:
- INNER JOIN: Returns records that have matching values in both tables.
- LEFT JOIN: Returns all records from the left table and matched records from the right
table.
- RIGHT JOIN: Returns all records from the right table and matched records from the left
table.
- FULL JOIN: Returns records when there is a match in either table.
Explain the use of subqueries in PostgreSQL.
A subquery is a query nested inside another query. It can be used in various clauses like
SELECT, WHERE, or FROM. Example:
SELECT name FROM users WHERE age IN (SELECT age FROM users WHERE name = 'Bob');
What is a Common Table Expression (CTE) and how is it used?
A CTE is a temporary result set that you can reference within a SELECT, INSERT, UPDATE,
or DELETE statement. It is defined using the WITH clause. Example:
WITH user_age AS (SELECT name, age FROM users)
SELECT * FROM user_age WHERE age > 25;
How do you perform a full-text search in PostgreSQL?
PostgreSQL provides full-text search capabilities using the tsvector and tsquery data types.
You can create a tsvector from text and then search it. Example:
SELECT * FROM articles WHERE to_tsvector('english', content) @@ to_tsquery('database');
Hibernate Interview Questions
Basics
What is Hibernate and what are its key features?
Hibernate is an Object-Relational Mapping (ORM) framework for Java that simplifies
database interactions. Key features include automatic SQL generation, support for caching,
and transaction management.
What is ORM (Object-Relational Mapping)?
ORM is a programming technique that allows developers to interact with a database using
high-level object-oriented programming languages instead of SQL. It maps database tables
to classes and rows to objects.
What are the advantages of using Hibernate over JDBC?
Advantages include reduced boilerplate code, automatic management of SQL queries, built-
in caching, and simplified transaction handling. Hibernate allows developers to focus on the
object-oriented model instead of SQL queries.
What is a session in Hibernate?
A session is a single-threaded, short-lived object that represents a conversation between the
application and the database. It is used to create, read, and delete objects in the database.
What is the Hibernate configuration file?
The Hibernate configuration file (usually hibernate.cfg.xml) contains settings for connecting
to the database, mapping classes to tables, and other Hibernate properties.
