Correct Answer:
C. Physical Level
The correct answer is the Physical Level. Database abstraction is a way to hide the complexities of how data is actually stored and managed, presenting users with a simpler, more conceptual view. There are typically three levels of abstraction in a database system:
- Physical Level: This is the lowest level of abstraction. It describes how the data is actually stored on the physical storage media (e.g., hard drives, SSDs). It details the complex low-level data structures, file organization, indexing techniques, and storage allocation strategies. Database administrators and system designers typically work at this level.
- Logical Level (or Conceptual Level): This level describes what data is stored in the database and the relationships among that data. It represents the entire database in terms of a schema, without detailing the physical storage structures. Programmers and database designers often work at this level.
- View Level (or External Level): This is the highest level of abstraction. It describes only part of the database, tailored to the needs of specific user groups. Users at this level only see the data relevant to them, simplifying interaction and enhancing security by hiding irrelevant or sensitive information.
The physical level is crucial for efficient data retrieval and storage management.