Difficulty: Easy
Correct Answer: Correct
Explanation:
Introduction / Context:
In enterprise systems, most business users do not run SQL against databases themselves. Instead, they use applications (web apps, mobile apps, desktop clients, or packaged software such as ERP/CRM) that communicate with a Database Management System (DBMS). The DBMS then manages persistent data and enforces security, integrity, and concurrency. The statement reflects this layered, enterprise-standard setup.
Given Data / Assumptions:
Concept / Approach:
Enterprise architecture separates concerns: presentation (UI), business logic (services), and data (DBMS). Applications authenticate and authorize users, validate inputs, and issue SQL/queries via the data access layer. The DBMS performs optimization, transaction management, and persistence. This indirection increases security, scalability, and maintainability.
Step-by-Step Solution:
Users initiate an action in an application (for example, “approve invoice”). The app validates rules and constructs the necessary data operations. The app sends queries/commands to the DBMS over a secure connection. The DBMS executes statements, enforces constraints, and commits or rolls back. Results flow back up to the app and are presented to the user.
Verification / Alternative check:
Consider APIs or microservices: even if there is a service layer between UI and DBMS, the application environment (service) is still the direct DBMS client. Direct end-user DBMS access is generally restricted to DBAs or analysts via tools, not typical business users.
Why Other Options Are Wrong:
“Incorrect” contradicts common enterprise design. “Depends on the operating system only” is irrelevant. “True only for NoSQL systems” and “Applies only to desktop databases” both mischaracterize architectures; the pattern is DBMS-agnostic.
Common Pitfalls:
Assuming users “directly” access database files; in reality, they access data through applications and the DBMS—not by opening data files.
Final Answer:
Correct
Discussion & Comments