GATE CSE 2026 Session 2 Q15: Match DBMS schema levels with what they describe

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

T	S
I: Logical schema	L: Views
II: Physical schema	M: File organization and indexes
III: External schema	N: Relations

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

Try it: multiple choice: exactly one correct option

Wrong answer costs 1/3 mark in GATE.

Show answer and explanation

Answer: C (official GATE 2026 final answer key)

Concept used: Three-schema architecture: conceptual (logical), physical (storage) and external (user views) levels.

First step: Ask which level describes storage structures and which describes what individual users see.

Full step-by-step solution

Detailed working, common mistakes and linked mock tests will be available with a free GATEiit account. Log-in is coming soon.

Share this question

Source: official GATE 2026 Session 2 CS question paper and final answer key, organised by IIT Guwahati. Question paper · Answer key