Database Management System (DBMS) MCQs
Practice DBMS MCQs covering database, data, information, DBMS, RDBMS and SQL basics with answers and explanations.
Question #1
Report Error
What is the primary difference between data and information?
Correct Answer: Option A
Explanation:
Data consists of raw, unprocessed facts, whereas information is data that has been processed and given meaning for decision-making.
Data consists of raw, unprocessed facts, whereas information is data that has been processed and given meaning for decision-making.
This question belongs to:
Computer
Database Management System (DBMS)
Question #2
Report Error
Which of the following best defines a Database?
Correct Answer: Option D
Explanation:
A database is an organized collection of related data stored electronically for efficient retrieval and management.
A database is an organized collection of related data stored electronically for efficient retrieval and management.
This question belongs to:
Computer
Database Management System (DBMS)
Question #3
Report Error
What does DBMS stand for?
Correct Answer: Option D
Explanation:
DBMS stands for Database Management System, which is software for creating and managing databases.
DBMS stands for Database Management System, which is software for creating and managing databases.
This question belongs to:
Computer
Database Management System (DBMS)
Question #4
Report Error
Which of the following is NOT an advantage of DBMS over traditional file systems?
Correct Answer: Option C
Explanation:
DBMS generally involves higher initial costs and complexity compared to simple file systems, though it offers better control over redundancy, independence, and security.
DBMS generally involves higher initial costs and complexity compared to simple file systems, though it offers better control over redundancy, independence, and security.
This question belongs to:
Computer
Database Management System (DBMS)
Question #5
Report Error
In DBMS, what is the role of a DBA?
Correct Answer: Option B
Explanation:
The Database Administrator (DBA) is responsible for designing, implementing, maintaining, and securing the database.
The Database Administrator (DBA) is responsible for designing, implementing, maintaining, and securing the database.
This question belongs to:
Computer
Database Management System (DBMS)
Question #6
Report Error
RDBMS is based on which model?
Correct Answer: Option D
Explanation:
Relational Database Management System (RDBMS) is based on the relational model proposed by E.F. Codd.
Relational Database Management System (RDBMS) is based on the relational model proposed by E.F. Codd.
This question belongs to:
Computer
Database Management System (DBMS)
Question #7
Report Error
What is a tuple in a relational database?
Correct Answer: Option B
Explanation:
In RDBMS, a tuple represents a single row or record in a relation (table).
In RDBMS, a tuple represents a single row or record in a relation (table).
This question belongs to:
Computer
Database Management System (DBMS)
Question #8
Report Error
Which SQL command is used to create a new table?
Correct Answer: Option B
Explanation:
The CREATE TABLE command in DDL is used to define a new table structure in SQL.
The CREATE TABLE command in DDL is used to define a new table structure in SQL.
This question belongs to:
Computer
Database Management System (DBMS)
Question #9
Report Error
What does DDL stand for in SQL?
Correct Answer: Option C
Explanation:
DDL (Data Definition Language) includes commands like CREATE, ALTER, DROP for defining database structures.
DDL (Data Definition Language) includes commands like CREATE, ALTER, DROP for defining database structures.
This question belongs to:
Computer
Database Management System (DBMS)
Question #10
Report Error
A Primary Key in RDBMS must be:
Correct Answer: Option C
Explanation:
A primary key uniquely identifies each record and cannot contain null values.
A primary key uniquely identifies each record and cannot contain null values.
This question belongs to:
Computer
Database Management System (DBMS)
