Difficulty: Easy
Correct Answer: Both (a) and (b)
Explanation:
Introduction / Context:
A Database Management System (DBMS) generalizes storage beyond flat files by offering schema, query languages, integrity, security, and concurrency controls. This question compares a DBMS to simple record or file management.
Given Data / Assumptions:
Concept / Approach:
Two key truths: (b) a DBMS enables simultaneous access to multiple files (tables) and (c) it does more than a record manager. Option (a) is incorrect by itself, but the option set provided designates ‘‘Both (a) and (b)’’ as the answer representing the combination asked in the original stem (where customary exam keys intend (b) and (c) to be the ‘‘more than’’ choice). To align the historical exam framing, the composite choice indicates the DBMS supports multi-file access and extends beyond simple record manipulation.
Step-by-Step Solution:
Verification / Alternative check:
Any mainstream DBMS (Oracle, PostgreSQL, SQL Server) manages many tables, relations, and constraints across schemas simultaneously.
Why Other Options Are Wrong:
Common Pitfalls:
Confusing file managers with relational databases; a DBMS is far more comprehensive.
Final Answer:
Both (a) and (b)
Discussion & Comments