Difficulty: Easy
Correct Answer: software system used to create, maintain, and provide controlled access to a database.
Explanation:
Introduction / Context:A Database Management System (DBMS) is the core software layer enabling data definition, storage, retrieval, security, and integrity. Understanding what a DBMS is clarifies its role versus hardware and application code.
Given Data / Assumptions:
Concept / Approach:The DBMS provides interfaces (SQL, drivers), enforces constraints, manages transactions (ACID), and secures data. It is unequivocally software; hardware merely hosts it. “Controlled access” is a fundamental property through roles, privileges, and policies.
Step-by-Step Solution:
Eliminate options labeling the DBMS as hardware.Select the option describing a software system with controlled access.Reject “uncontrolled access” because DBMSs exist to enforce control.Verification / Alternative check:Vendor documentation (Oracle, SQL Server, PostgreSQL, MySQL) defines a DBMS as software providing storage, query processing, security, and recovery.
Why Other Options Are Wrong:Hardware options misclassify the DBMS. Uncontrolled access contradicts core DBMS purpose and security features.
Common Pitfalls:Confusing DBMS (software) with DB (data) or with the physical server. The DBMS is the software layer managing the database.
Final Answer:software system used to create, maintain, and provide controlled access to a database.
Discussion & Comments