Database Management System (DBMS) MCQs
Practice DBMS MCQs covering database, data, information, DBMS, RDBMS and SQL basics with answers and explanations.
Question #21
Report Error
The command to modify existing records in a table is:
Correct Answer: Option B
Explanation:
UPDATE is the DML command used to modify data in existing rows.
UPDATE is the DML command used to modify data in existing rows.
This question belongs to:
Computer
Database Management System (DBMS)
Question #22
Report Error
Which normal form eliminates transitive dependencies?
Correct Answer: Option B
Explanation:
Third Normal Form (3NF) removes transitive dependencies on non-prime attributes.
Third Normal Form (3NF) removes transitive dependencies on non-prime attributes.
This question belongs to:
Computer
Database Management System (DBMS)
Question #23
Report Error
What is metadata?
Correct Answer: Option B
Explanation:
Metadata is data that provides information about other data, such as structure and constraints.
Metadata is data that provides information about other data, such as structure and constraints.
This question belongs to:
Computer
Database Management System (DBMS)
Question #24
Report Error
In SQL, the WHERE clause is used in:
Correct Answer: Option B
Explanation:
WHERE clause filters records in SELECT, UPDATE, and DELETE operations.
WHERE clause filters records in SELECT, UPDATE, and DELETE operations.
This question belongs to:
Computer
Database Management System (DBMS)
Question #25
Report Error
A view in DBMS is:
Correct Answer: Option C
Explanation:
A view is a virtual table derived from one or more base tables.
A view is a virtual table derived from one or more base tables.
This question belongs to:
Computer
Database Management System (DBMS)
Question #26
Report Error
Which of the following ensures data integrity in RDBMS?
Correct Answer: Option C
Explanation:
Integrity constraints such as keys enforce rules for valid data.
Integrity constraints such as keys enforce rules for valid data.
This question belongs to:
Computer
Database Management System (DBMS)
Question #27
Report Error
What is the main purpose of indexing in a database?
Correct Answer: Option A
Explanation:
Indexes improve the speed of data retrieval operations on a database table.
Indexes improve the speed of data retrieval operations on a database table.
This question belongs to:
Computer
Database Management System (DBMS)
Question #28
Report Error
DCL commands in SQL include:
Correct Answer: Option B
Explanation:
Data Control Language (DCL) commands manage access permissions.
Data Control Language (DCL) commands manage access permissions.
This question belongs to:
Computer
Database Management System (DBMS)
Question #29
Report Error
Which model represents data in the form of tables?
Correct Answer: Option D
Explanation:
The relational model uses tables (relations) to represent data and relationships.
The relational model uses tables (relations) to represent data and relationships.
This question belongs to:
Computer
Database Management System (DBMS)
Question #30
Report Error
Information is:
Correct Answer: Option C
Explanation:
Information is data that has been organized and processed to provide context and meaning.
Information is data that has been organized and processed to provide context and meaning.
This question belongs to:
Computer
Database Management System (DBMS)
