Statements A, B and D correctly describe the functions and benefits of a DBMS, while C is incorrect. A DBMS is designed to minimise unnecessary redundancy, provide powerful query capabilities and enforce integrity and security rules. Maximising redundancy would waste storage and lead to inconsistency, which is contrary to database design principles. Therefore, the combination A, B and D only is the correct set of statements.
Option A:
Option A is incomplete because it includes A and B but omits D. While defining and querying data are important, recognising the integrity and security roles of a DBMS is also essential for a complete understanding.
Option B:
Option B is incomplete because it lists only B and D and leaves out A. Without acknowledging that a DBMS defines and maintains databases, the foundational purpose of such systems is not fully captured.
Option C:
Option C is correct because it gathers A, B and D, the three true statements, and rejects C, which misunderstands the goal of controlling redundancy. It presents a coherent picture of how DBMS technology supports reliable data management.
Option D:
Option D is incorrect because it considers all four statements as correct and hence accepts C. Since C conflicts with the aim of reducing redundant data, any option that includes it cannot be correct.
Comment Your Answer
Please login to comment your answer.
Sign In
Sign Up
Answers commented by others
No answers commented yet. Be the first to comment!