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:
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