IAE Academy

GATE 2026 CS2 Q.15: solution and answer

GATE 2026 · CS2Q.15 · 1 mark · MCQ

In the context of DBMS, consider the two sets T and S given below.

Which one of the following is the correct match from T to S?

GATE 2026 CS2 question 15: A two-column table headed T and S with three rows: I: Logical schema with L: Views;Tap to open full size
Figure from the GATE 2026 CS2 paper. It is part of the question.
Figure description

A two-column table headed T and S with three rows: I: Logical schema with L: Views; II: Physical schema with M: File organization and indexes; III: External schema with N: Relations.

  1. (A)

    I – L, II – M, III – N

  2. (B)

    I – M, II – L, III – N

  3. (C)

    I – N, II – M, III – L

  4. (D)

    I – N, II – L, III – M

Answer and solution

ANSWER

The correct match is I – N, II – M, III – L, which is option (C).

Official answer: CSource: Official answer key, GATE 2026 CS2 (IIT Guwahati)

  1. The three-schema architecture has three levels: external (the user views), conceptual (logical) and internal (physical).

  2. The logical (conceptual) schema describes the whole database in terms of the data model. In the relational model this is the set of relations (tables), so I matches N.

  3. The physical (internal) schema describes how the data is stored: file organization and indexes. So II matches M.

  4. The external schema describes what each user group sees, which is defined through views. So III matches L.

  5. The match is I – N, II – M, III – L. Check against the options: (A) pairs I with L and (B) pairs I with M, both wrong; (D) pairs II with L, wrong. Only option (C) fits.

KEY IDEA

The three-schema architecture maps the logical (conceptual) schema to relations, the physical (internal) schema to file organization and indexes, and the external schema to views.

WATCH OUT FOR

Matching the logical schema with views, or the external schema with relations. Views are what users see (external). Relations make up the logical design of the whole database.

From the GATE 2026 CS2 paper. Every question of this paper · Download the full paper · All 13 Relational algebra questions, with notes

More Relational algebra questions