Difficulty: Easy
Correct Answer: Does not apply (incorrect: DBMS activities belong to data management)
Explanation:
Introduction / Context:
In layered or three-tier architectures, responsibilities are separated into presentation, processing (business/application), and data management components. This question checks whether you can correctly place DBMS responsibilities.
Given Data / Assumptions:
Concept / Approach:
DBMS activities—parsing/optimizing SQL, maintaining indexes, enforcing ACID properties—are part of the data management component, not the processing (business) logic. Business code calls the DBMS through drivers/ORMs, but the engine’s work is conceptually and operationally distinct from the application tier.
Step-by-Step Solution:
Verification / Alternative check:
Examine deployment diagrams: DB server(s) are separate processes/services with their own resource management and security boundaries.
Why Other Options Are Wrong:
Common Pitfalls:
Collapsing tiers conceptually; assuming ORMs make the DBMS part of the application layer; overlooking administrative DB tasks that are independent of application code.
Final Answer:
Does not apply (incorrect: DBMS activities belong to data management)
Discussion & Comments