Match the following :

2026

Match the following :

image.png

  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–L, II–N, III–M

Attempted by 2255 students.

Show answer & explanation

Correct answer: C

The correct matching is based on the Three-Schema Architecture of a Database Management System.

1. External Schema (III): This level describes the user views. It matches with L: Views.

2. Logical Schema (I): This level describes the structure of the whole database, typically using relations. It matches with N: Relations.

3. Physical Schema (II): This level describes how data is stored, including file organization and indexes. It matches with M: File organization and indexes.

Therefore, the correct matching is I–N, II–M, III–L.

A video solution is available for this question — log in and enroll to watch it.

Explore the full course: Gate Guidance By Sanchit Sir