Practice rdbms Quizzes
Prepare for technical interviews with high-quality rdbms quizzes that mirror real industry questions. Each quiz helps you master concepts, improve problem-solving speed and gain the confidence needed for coding tests. Whether revising basics or tackling advanced scenarios, these quizzes ensure structured, effective preparation.
Explore All rdbms Quizzes
Learn rdbms step by step with interactive quizzes designed for beginners and learners revising key concepts. Build a strong foundation with clear, structured practice in rdbms.
Question 1
Which of the following best describes an RDBMS?
1
A database system that stores data in key-value pairs
2
A database system that only allows unstructured data storage
3
A database system that organizes data in tables with relationships
4
A file-based system for data storage
Question 2
In a relational database, what does a foreign key do?
1
Automatically indexes data
2
Establishes a relationship between two tables
3
Ensures a table has at least one row
4
Uniquely identifies a row in a table
Question 3
Which of the following is an example of an RDBMS?
1
Firebase
2
MongoDB
3
Neo4j
4
MySQL
Question 4
What is the purpose of the PRIMARY KEY in a table?
1
To create foreign keys
2
To store null values
3
To uniquely identify each row
4
To allow duplicate values
Question 5
In a relational database, what does normalization help to achieve?
1
Slowing down performance
2
Reducing redundancy
3
Increasing redundancy
4
Increasing complexity
Question 6
What is the primary advantage of using a key-value store over a relational database?
1
Fast lookup and retrieval of data
2
Requires less storage space
3
Stronger ACID compliance
4
Better support for complex joins
Question 7
What is the primary disadvantage of key-value stores compared to relational databases?
1
Requires more memory
2
Does not support distributed systems
3
Poor performance for key lookups
4
Lack of complex query capabilities
Question 8
Which of the following is NOT an example of a key-value database?
1
DynamoDB
2
PostgreSQL
3
Memcached
4
Cassandra
Question 9
Which SQL statement is used to retrieve unique values from a column?
1
SELECT column_name FROM table_name WHERE DISTINCT;
2
SELECT DIFFERENT column_name FROM table_name;
3
SELECT DISTINCT column_name FROM table_name;
4
SELECT UNIQUE column_name FROM table_name;
Question 10
What does SQL stand for?
1
Structured Query Language
2
System Query Language
3
Sequential Query Language
4
Standardized Query Logic
Question 11
Which SQL command is used to remove all records from a table without deleting the table structure?
1
TRUNCATE
2
CLEAR
3
DELETE
4
DROP
Question 12
Which SQL join returns only the matching rows from both tables?
1
INNER JOIN
2
RIGHT JOIN
3
FULL JOIN
4
LEFT JOIN
Question 13
Which SQL constraint ensures that a column cannot have NULL values?
1
PRIMARY KEY
2
UNIQUE
3
CHECK
4
NOT NULL
Question 14
Which of the following is NOT an SQL aggregate function?
1
AVG()
2
COUNT()
3
CONCAT()
4
SUM()
Question 15
Which SQL clause is used to filter records from a table?
1
WHERE
2
ORDER BY
3
GROUP BY
4
HAVING
Question 16
Which SQL JOIN returns all records from the left table and only matching records from the right table?
1
INNER JOIN
2
RIGHT JOIN
3
FULL JOIN
4
LEFT JOIN
Question 17
Which constraint is used to ensure that all values in a column are unique?
1
UNIQUE
2
NOT NULL
3
FOREIGN KEY
4
CHECK
Question 18
Which SQL clause is used with aggregate functions to group results?
1
DISTINCT
2
GROUP BY
3
HAVING
4
ORDER BY
Question 19
Which database index type speeds up text searches in SQL?
1
Full-Text Index
2
Hash Index
3
Clustered Index
4
B-Tree Index
Question 20
Which SQL command is used to permanently save changes in a transaction?
1
DELETE
2
SAVEPOINT
3
ROLLBACK
4
COMMIT
Question 21
Which normal form removes partial dependency?
1
2NF
2
3NF
3
BCNF
4
1NF
Question 22
Which index type does MySQL use by default for primary keys?
1
Hash Index
2
B-Tree Index
3
Bitmap Index
4
Full-Text Index
Question 23
Which SQL command creates a virtual table?
1
CREATE INDEX
2
CREATE TABLE
3
CREATE VIEW
4
CREATE PROCEDURE
Question 24
Which keyword is used to define an output parameter in an SQL stored procedure?
1
RETURN
2
OUTPUT
3
RESULT
4
OUT
Question 25
Which ACID property ensures that once a transaction is committed, it remains so even in case of system failure?
1
Durability
2
Isolation
3
Atomicity
4
Consistency
Question 26
What is the main goal of normalization in a database?
1
To increase redundancy
2
To store data in a single large table
3
To minimize redundancy and improve data integrity
4
To reduce data integrity
Question 27
What does ACID stand for in DBMS?
1
Access, Control, Integrity, Data
2
Accuracy, Consistency, Isolation, Database
3
Automation, Control, Integrity, Dependency
4
Atomicity, Consistency, Isolation, Durability
Question 28
Which of the following is NOT a type of database model?
1
Linear
2
Graph-based
3
Hierarchical
4
Network
Question 29
Which of the following SQL commands is used to remove all records from a table but keep its structure?
1
DROP
2
ALTER
3
DELETE
4
TRUNCATE
Question 30
Which of the following is an advantage of NoSQL databases over traditional RDBMS?
1
Schema flexibility
2
Better horizontal scalability
3
Handling unstructured data
4
All of the above