Which of the following refers to the level of data abstraction that describes…

2025

Which of the following refers to the level of data abstraction that describes exactly how the data is actually stored?

  1. A.

    Conceptual Level

  2. B.

    Physical Level

  3. C.

    File Level

  4. D.

    Logical Level

Attempted by 643 students.

Show answer & explanation

Correct answer: B

Concept

Data abstraction in a DBMS hides storage complexity from users using the ANSI/SPARC three-schema architecture, which defines three levels of abstraction: the External (View) level, the Conceptual (Logical) level, and the Internal (Physical) level. The internal/physical level is the one that specifies exactly HOW the data is actually stored on the storage medium.

The three levels

  • External (View) level: how individual users or applications see the data; multiple customized views over the same database.

  • Conceptual (Logical) level: what data is stored and the relationships among it (entities, attributes, constraints, the whole schema), independent of any storage detail. Many textbooks use the words Conceptual and Logical interchangeably for this single level.

  • Internal (Physical) level: how the data is actually stored — file organization, record/block layout, indexing structures, access paths and hardware-specific arrangements.

Application

The question asks for the level that describes exactly HOW the data is actually stored. That is precisely the responsibility of the internal level, which is the Physical Level. So the correct answer is Physical Level.

Why the other choices do not fit

  • Conceptual Level / Logical Level describe WHAT data is stored and how it is related — the schema — not the storage mechanics, so neither captures the physical storage detail the question targets.

  • File Level is not a level of the standard three-schema abstraction architecture at all; file organisation is just one storage detail handled inside the physical level.

Explore the full course: Bpsc