Match the following :

2026

Match the following :

image.png

Answer: C. I–N, II–M, III–LThe correct matching is based on the Three-Schema Architecture of a Database Management System. 1. External Schema (III): This level describes the user views.…

  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 2710 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: Iocl Engineers Officers Grade A Paper 2

Loading lesson…