The view of a database that is presented to an application program is known as:

2007

The view of a database that is presented to an application program is known as:

Answer: B. SubschemaConceptIn the three-schema approach, a database can be described at internal, conceptual, and external levels. An external-level description exposes only the…

  1. A.

    Schema

  2. B.

    Subschema

  3. C.

    Virtual table

  4. D.

    Index table

Attempted by 2606 students.

Show answer & explanation

Correct answer: B

Concept

In the three-schema approach, a database can be described at internal, conceptual, and external levels.

An external-level description exposes only the data and relationships needed by a particular user or application while hiding the rest of the database design.

Application

The stem asks for the name of this application-specific external description. That description is a subschema, because it selects the relevant part of the broader database schema for one application program.

Contrast

  • Schema: the overall formal organization of database data, relationships, and constraints.

  • Virtual table: a query-defined relation, commonly called a view in SQL.

  • Index table: an access structure used to locate records efficiently.

Cross-check

Cross-check: replacing “application program” with “external view” preserves the same three-schema-level meaning, which points to subschema rather than a query result or an access structure.

Result

Therefore, the required term is subschema.

Explore the full course: Iocl Engineers Officers Grade A Paper 2

Loading lesson…