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. Subschema — ConceptIn the three-schema approach, a database can be described at internal, conceptual, and external levels. An external-level description exposes only the…
- A.
Schema
- B.
Subschema
- C.
Virtual table
- 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