Practice dbms Quizzes
Sharpen your technical edge with advanced dbms quizzes built for serious learners and professionals. These quizzes challenge your reasoning, improve retention and provide hands-on practice similar to real engineering scenarios. Perfect for upskilling and interview preparation.
Explore All dbms Quizzes
Learn dbms step by step with interactive quizzes designed for beginners and learners revising key concepts. Build a strong foundation with clear, structured practice in dbms.
Question 1
What is a Database Management System (DBMS)?
1
A programming language for creating applications
2
A network management tool
3
A hardware device for storing data
4
A software that manages and organizes data in a database
Question 2
What is the primary function of a Database Management System (DBMS)?
1
Optimize CPU performance
2
Perform network communication
3
Store and retrieve data efficiently
4
Manage operating system processes
Question 3
Which of the following is NOT a type of data model in DBMS?
1
Cloud model
2
Hierarchical model
3
Network model
4
Object-oriented model
Question 4
Which of the following is a key difference between SQL and NoSQL databases?
1
SQL databases store data in documents, NoSQL stores data in tables
2
SQL databases are schema-less, NoSQL databases require a strict schema
3
SQL databases use structured query language, NoSQL uses flexible data models
4
SQL databases do not support transactions, while NoSQL does
Question 5
Which ACID property ensures that once a transaction is committed, it remains so even in case of system failure?
1
Isolation
2
Atomicity
3
Durability
4
Consistency
Question 6
What is the main goal of normalization in a database?
1
To store data in a single large table
2
To reduce data integrity
3
To increase redundancy
4
To minimize redundancy and improve data integrity
Question 7
Which of the following is NOT a type of data model in DBMS?
1
Hierarchical model
2
Network model
3
Object-oriented model
4
All of the above
Question 8
Which of the following is an advantage of distributed databases?
1
No need for replication
2
Faster data retrieval in all cases
3
Improved reliability and availability
4
Complete elimination of data redundancy
Question 9
What does ACID stand for in DBMS?
1
Access, Control, Integrity, Data
2
Atomicity, Consistency, Isolation, Durability
3
Accuracy, Consistency, Isolation, Database
4
Automation, Control, Integrity, Dependency
Question 10
Which of the following is NOT a type of database model?
1
Hierarchical
2
Graph-based
3
Network
4
Linear
Question 11
Which of the following indexing techniques is used in DBMS?
1
B-Tree
2
Hashing
3
Bitmap Indexing
4
All of the above
Question 12
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
Question 13
What does SQL stand for?
1
Structured Query Language
2
Sequential Query Language
3
System Query Language
4
Standardized Query Logic
Question 14
Which of the following best describes an RDBMS?
1
A database system that organizes data in tables with relationships
2
A database system that stores data in key-value pairs
3
A file-based system for data storage
4
A database system that only allows unstructured data storage
Question 15
In a relational database, what does a foreign key do?
1
Uniquely identifies a row in a table
2
Automatically indexes data
3
Ensures a table has at least one row
4
Establishes a relationship between two tables
Question 16
Which of the following is an example of an RDBMS?
1
Neo4j
2
Firebase
3
MySQL
4
MongoDB
Question 17
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 18
Which of the following SQL commands is used to remove all records from a table but keep its structure?
1
ALTER
2
DROP
3
DELETE
4
TRUNCATE
Question 19
In a relational database, what does normalization help to achieve?
1
Reducing redundancy
2
Increasing complexity
3
Slowing down performance
4
Increasing redundancy
Question 20
Which isolation level allows dirty reads?
1
REPEATABLE READ
2
SERIALIZABLE
3
READ COMMITTED
4
READ UNCOMMITTED
Question 21
Which index type is most effective for columns with low cardinality?
1
Hash Index
2
Full-Text Index
3
Bitmap Index
4
B-Tree Index
Question 22
Which data access pattern is key-value stores best optimized for?
1
Direct lookup using a unique key
2
Multi-table aggregation
3
Range-based queries
4
Complex joins across tables