Question

Which of the following is used to Manage Data Base?

• A. Operating System
• B. Complier
• C. Cache Memory
• D. DBMS

Hint:

Remember the acronyms:
- OS: Operating System (manages computer resources)
- DBMS: Database Management System (manages data)
- RAM: Random Access Memory (primary storage)
- CPU: Central Processing Unit (processor)

Answer 1

The Correct Option is D

Grouping the four options by what kind of computing element they are quickly narrows things down.

1. Cache Memory: This is a hardware component, a fast physical memory layer, not software at all, so it cannot "manage" a database in the software sense the question means.
2. Compiler: This is software, but its entire purpose is translating program code into machine instructions, unrelated to organizing stored data.
3. Operating System: This is software too, but a general-purpose one that manages the whole computer's hardware and other programs, it can host a database but does not manage the data within it.
4. DBMS: This is software built for exactly one purpose, managing databases, handling how data is stored, indexed, retrieved, and secured.

Only one of the four is a specialized software system dedicated to database management, and that is the DBMS.