Database Modeling and Design MCQs with Answers
Practice important Database Modeling and Design MCQs with answers and explanations.
Multiple Choice Questions
Q21: Which of the following is a major disadvantage of flat file databases?
- A: High complexity
- B: High speed
- C: Data redundancy and unreliability
- D: Strong data relationships
View Answer
C
Q22: In a hierarchical database, how is data structured?
- A: In rows and columns with no hierarchy
- B: In a web-like structure
- C: In a tree-like structure
- D: In a random order
View Answer
C
Q23: What type of relationship is represented in a hierarchical database model?
- A: One-to-one
- B: One-to-many
- C: Many-to-many
- D: No relationships
View Answer
B
Q24: What is the rule for the parent-child relationship in a hierarchical database?
- A: One parent can have many children, and children can have multiple parents
- B: One parent can have many children, but children can only have one parent
- C: One child can have multiple parents
- D: There is no restriction
View Answer
B
Q25: Which data model was proposed by IBM's IMS system?
- A: Flat File
- B: Hierarchical
- C: Relational
- D: Object-Oriented
View Answer
B
Q26: What is a key challenge when retrieving data from a hierarchical database?
- A: Data redundancy
- B: Traversing the entire tree from the root node
- C: High speed of retrieval
- D: Unstructured data
View Answer
B
Q27: What happens when more records are added to a flat file database?
- A: Data integrity improves
- B: Data redundancy decreases
- C: Data redundancy increases
- D: It becomes easier to update records
View Answer
C
Q28: What does the 3-Tier Architecture primarily divide an application into?
- A: 2 layers
- B: 3 layers
- C: 4 layers
- D: 5 layers
View Answer
B
Q29: What is the topmost layer in the 3-Tier Architecture known as?
- A: Data Layer
- B: Application Layer
- C: Presentation Layer
- D: Logic Layer
View Answer
C
Q30: Which layer is responsible for storing data in the 3-Tier Architecture?
- A: Logic Layer
- B: Presentation Layer
- C: Data Layer
- D: Application Layer
View Answer
C