Question 1
What is a Database Management System (DBMS)?
1
A programming language for creating applications
2
A network management tool
3
A software that manages and organizes data in a database
4
A hardware device for storing data
Question 2
What is the primary function of a Database Management System (DBMS)?
1
Optimize CPU performance
2
Store and retrieve data efficiently
3
Perform network communication
4
Manage operating system processes
Question 3
Which of the following is NOT a type of data model in DBMS?
1
Network model
2
Hierarchical model
3
Cloud 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 use structured query language, NoSQL uses flexible data models
3
SQL databases are schema-less, NoSQL databases require a strict schema
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
Consistency
3
Durability
4
Atomicity
Question 6
What is the main goal of normalization in a database?
1
To reduce data integrity
2
To store data in a single large table
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
Complete elimination of data redundancy
4
Improved reliability and availability
Question 9
What does ACID stand for in DBMS?
1
Access, Control, Integrity, Data
2
Automation, Control, Integrity, Dependency
3
Atomicity, Consistency, Isolation, Durability
4
Accuracy, Consistency, Isolation, Database
Question 10
Which of the following is NOT a type of database model?
1
Graph-based
2
Hierarchical
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
Sequential Query Language
2
System Query Language
3
Structured Query Language
4
Standardized Query Logic
Question 14
Which of the following best describes an RDBMS?
1
A database system that stores data in key-value pairs
2
A database system that organizes data in tables with relationships
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
Establishes a relationship between two tables
4
Ensures a table has at least one row
Question 16
Which of the following is an example of an RDBMS?
1
Firebase
2
Neo4j
3
MongoDB
4
MySQL
Question 17
What is the purpose of the PRIMARY KEY in a table?
1
To allow duplicate values
2
To store null values
3
To create foreign keys
4
To uniquely identify each row
Question 18
Which of the following SQL commands is used to remove all records from a table but keep its structure?
1
DELETE
2
DROP
3
ALTER
4
TRUNCATE
Question 19
In a relational database, what does normalization help to achieve?
1
Reducing redundancy
2
Slowing down performance
3
Increasing redundancy
4
Increasing complexity