Database Modeling and Design MCQs with Answers
Practice important Database Modeling and Design MCQs with answers and explanations.
Multiple Choice Questions
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
View Answer
B
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
View Answer
B
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
View Answer
C
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
View Answer
B
Q35: The Presentation Layer communicates with which of the following?
- A: Data Layer
- B: External Systems
- C: Application Layer
- D: End Users Only
View Answer
C
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
View Answer
C
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
View Answer
B
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
View Answer
C
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
View Answer
A
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
View Answer
B