Database Management System (DBMS) MCQs with Answers
Q. 1 Which of the following is not a type of database model?
Check Solution
Ans: D
Distributed databases are an architecture, not a basic database model. The main models are Hierarchical, Relational, and Network.
Q. 2 What does SQL stand for?
Check Solution
Ans: A
SQL stands for Structured Query Language, used to manage and query relational databases.
Q. 3 Which command is used to remove all rows from a table without deleting the table structure?
Check Solution
Ans: C
TRUNCATE removes all rows from a table but retains the structure for future use.
Q. 4 Which normal form removes partial dependency?
Check Solution
Ans: B
2NF removes partial dependency, i.e., dependency of a non-prime attribute on part of a composite key.
Q. 5 Which key uniquely identifies a record in a table?
Check Solution
Ans: B
The Primary Key uniquely identifies each record in a table.
Q. 6 Which SQL clause is used to filter records?
Check Solution
Ans: B
The WHERE clause filters records based on specified conditions.
Q. 7 Which of the following is a DML command?
Check Solution
Ans: C
INSERT is a Data Manipulation Language (DML) command used to add data to tables.
Q. 8 In ER diagrams, a diamond shape represents?
Check Solution
Ans: C
In ER diagrams, a diamond shape represents a Relationship between entities.
Q. 9 Which indexing method uses a tree-like structure for searching?
Check Solution
Ans: B
B-Tree indexing uses a balanced tree structure for efficient searching and retrieval.
Q. 10 Which isolation level prevents dirty reads?
Check Solution
Ans: B
Read Committed prevents dirty reads by ensuring only committed data can be read.
Next Topic: DSA Programming MCQs with Answers for Placements
Practice Aptitude Questions for Placements
Crack Placement Tests: Faster & Smarter
Adaptive Practice | Real Time Insights | Resume your Progress
