Database Modeling and Design MCQs with Answers
Practice important Database Modeling and Design MCQs with answers and explanations.
Chapter: 2
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
Correct Answer:
C
Chapter: 2
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
Correct Answer:
C
Chapter: 2
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
Correct Answer:
B
Chapter: 2
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
Correct Answer:
B
Chapter: 2
Q25:
Which data model was proposed by IBM's IMS system?
A. Flat File
B. Hierarchical
C. Relational
D. Object-Oriented
Correct Answer:
B
Chapter: 2
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
Correct Answer:
B
Chapter: 2
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
Correct Answer:
C
Chapter: 3
Q28:
What does the 3-Tier Architecture primarily divide an application into?
A. 2 layers
B. 3 layers
C. 4 layers
D. 5 layers
Correct Answer:
B
Chapter: 3
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
Correct Answer:
C
Chapter: 3
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
Correct Answer:
C
Chapter: 3
Q31:
What is another name for the Application Layer in 3-Tier Architecture?
A. Data Tier
B. Business Logic Layer
C. Presentation Layer
D. Storage Layer
Correct Answer:
B
Chapter: 3
Q32:
In the 3-Tier Architecture, what happens if one tier fails?
A. The entire system crashes
B. The other tiers continue to function
C. The system restarts
D. The system requires a full reset
Correct Answer:
B
Chapter: 3
Q33:
Which layer is responsible for executing business rules and logic in 3-Tier Architecture?
A. Presentation Layer
B. Data Layer
C. Application Layer
D. External Layer
Correct Answer:
C
Chapter: 3
Q34:
How does the Data Layer communicate with other layers in 3-Tier Architecture?
A. Directly with users
B. Only with the Application Layer
C. With both Application and Presentation layers
D. With the Presentation Layer only
Correct Answer:
B
Chapter: 3
Q35:
The Presentation Layer communicates with which of the following?
A. Data Layer
B. External Systems
C. Application Layer
D. End Users Only
Correct Answer:
C
Chapter: 3
Q36:
Which layer is responsible for formatting input/output data into a presentable form in the 3-Tier Architecture?
A. Data Layer
B. Business Logic Layer
C. Presentation Layer
D. Internal Layer
Correct Answer:
C
Chapter: 3
Q37:
What is the role of the Application Programmer in DBMS?
A. Manages the physical realization of the database
B. Develops applications to provide required functionality
C. Ensures the security of the database
D. Designs the database schema
Correct Answer:
B
Chapter: 3
Q38:
In a Client-Server architecture, what does the client do?
A. Stores the data
B. Processes all requests
C. Sends requests to the server
D. Manages server connections
Correct Answer:
C
Chapter: 3
Q39:
Which layer in the 3-Tier Architecture does the following request: "Get Total Sales"?
A. Presentation Layer
B. Data Layer
C. Application Layer
D. External Layer
Correct Answer:
A
Chapter: 3
Q40:
The layer responsible for passing requests and responses between users and databases is called the _______.
A. Data Layer
B. Application Layer
C. Presentation Layer
D. Physical Layer
Correct Answer:
B