Which level of abstraction describes how data are stored in the database?
2012
Which level of abstraction describes how data are stored in the database?
Answer: A. Physical level — ConceptA database is described at three levels of abstraction, and each level answers a different question about the same data. The physical level answers how…
- A.
Physical level
- B.
View level
- C.
Abstraction level
- D.
Logical level
Attempted by 331 students.
Show answer & explanation
Correct answer: A
Concept
A database is described at three levels of abstraction, and each level answers a different question about the same data. The physical level answers how the data are stored, the logical level answers what data are stored and how those items relate to one another, and the view level answers which part of the data a particular user or application is shown.
Applying it here
The stem asks for the level whose description is about storage itself — the way the data are laid out on the storage device. That is the lowest of the three levels, the physical level: it fixes the file organisation, the layout of records and blocks, the access paths and index structures, and the encoding or compression used on disk.
Level | What its description covers |
|---|---|
Physical level | How the data are stored: file organisation, record and block layout, indexes and encoding on the device |
Logical level | What data are stored and the relationships among those items, written as the schema |
View level | Which portion of the database a particular user or application is shown, with the rest hidden |
Cross-check
Test the other names against the same question. A description of what data are held and how they relate is the logical level; a description of the slice shown to one user or application is the view level; and "abstraction level" is the umbrella name of the three-level scheme itself rather than one of its tiers. Only the physical level is defined in terms of storage, so the answer is Physical level.
A video solution is available for this question — log in and enroll to watch it.