Important DBMS Basics MCQ Questions with Answers (Set 1) | IBPS, GATE
Practice DBMS Basics MCQ questions with answers and explanations. These questions cover important concepts like 3-tier architecture, database models, ACID properties, schema, and data abstraction. Useful for IBPS IT Officer, GATE, and other competitive exams.
Difficulty: Easy to Medium
Total Questions: 15
DBMS Basics MCQ Questions
Q1. In the 3-tier DBMS architecture, which level describes how data is physically stored?
A. External Level
B. Conceptual Level
C. Internal Level
D. User View Level
View Answer
Answer: C
Explanation: The Internal Level (Physical Schema) deals with physical storage details like blocks, pointers, and indexes.
Q2. The Conceptual Level is concerned with:
A. Physical storage
B. User views
C. Logical structure of data
D. Hardware specifications
View Answer
Answer: C
Explanation: It defines tables, relationships, and constraints independent of storage.
Q3. Which model uses a tree-like structure?
A. Relational
B. Network
C. Hierarchical
D. Object-Oriented
View Answer
Answer: C
Explanation: The hierarchical model follows parent-child relationships.
Q4. Degree of a relation refers to:
A. Number of rows
B. Number of columns
C. Constraints
D. Tables
View Answer
Answer: B
Explanation: Degree = number of attributes (columns).
Q5. Network model allows:
A. One-to-one only
B. Many-to-many relationships
C. Cloud storage
D. No indexing
View Answer
Answer: B
Explanation: It uses graph structure allowing multiple parents.
Q6. Cardinality of a table with 50 records is:
A. 5
B. 50
C. 10
D. 250
View Answer
Answer: B
Explanation: Cardinality = number of rows.
Q7. Which ensures database consistency during failures?
A. Multi-user access
B. Data Independence
C. ACID properties
D. Data Abstraction
View Answer
Answer: C
Explanation: ACID ensures reliable and consistent transactions even during failures.
Q8. In Network Model, relationships are called:
A. Tree
B. Table
C. Set
D. Schema
View Answer
Answer: C
Explanation: A set includes owner and member records.
Q9. Which level is closest to end-users?
A. Physical Level
B. Internal Level
C. Conceptual Level
D. External Level
View Answer
Answer: D
Explanation: External level provides user-specific views.
Q10. Root node is used in:
A. Relational
B. Hierarchical
C. Network
D. Flat file
View Answer
Answer: B
Explanation: Hierarchical model starts from root node.
Q11. Tuple means:
A. Column
B. Row
C. Table
D. Key
View Answer
Answer: B
Explanation: Tuple = row.
Q12. DBMS advantage over file system:
A. More redundancy
B. Inconsistency
C. Reduced redundancy
D. No security
View Answer
Answer: C
Explanation: DBMS reduces duplication and improves consistency.
Q13. Structure of database is called:
A. Instance
B. Schema
C. Tuple
D. Attribute
View Answer
Answer: B
Explanation: Schema defines structure.
Q14. Owner and Member correspond to:
A. Parent and Child
B. Rows and Columns
C. Tables and Views
D. Keys and Constraints
View Answer
Answer: A
Explanation: Owner = parent, Member = child.
Q15. Data independence means:
A. Independent storage
B. Schema changes don’t affect higher levels
C. No password required
D. No OS required
View Answer
Answer: B
Explanation: Changes at one level don’t affect higher levels.
Conclusion
These DBMS Basics MCQ questions help build a strong foundation in database concepts such as architecture, models, ACID properties, and schema design. Regular practice improves accuracy and confidence for competitive exams.
For detailed concepts, refer to DBMS fundamentals .