GATE CS 2026 Set 2 — Question 15

MCQ+1 / -0.33EasyDatabasesRelations & DomainsRelational ModelViewsSQLIndexing & File Organization

Databases → Indexing & File Organization → Relations & Domains

Last updated 5 September 2026

Question

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 ?

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

Correct answer (C) I - N, II - M, III - L Solution In the three-schema architecture of a DBMS: 1. Logical Schema (Conceptual Level): Describes the logical structure of the entire database, including entities, attributes, and relationships. In a relational DBMS, this is represented by Relations (tables). Thus, I matches N . 2. Physical Schema (Internal Level): Describes the physical storage structures and access paths. This includes details like File organization and indexes . Thus, II matches M . 3. External Schema (View Level): Describes the part of the database that is visible to specific user groups. This level consists of various Views . Thus, III matches L . Therefore, the correct matching is I - N, II - M, III - L. Turn this into a strength. Explore AI-powered practice and doubt support with Success Tracker.

Review answer and solution without JavaScript

Interactive answer checking needs JavaScript. The published solution is available below.

Correct answer (C) I - N, II - M, III - L Solution In the three-schema architecture of a DBMS: 1. Logical Schema (Conceptual Level): Describes the logical structure of the entire database, including entities, attributes, and relationships. In a relational DBMS, this is represented by Relations (tables). Thus, I matches N . 2. Physical Schema (Internal Level): Describes the physical storage structures and access paths. This includes details like File organization and indexes . Thus, II matches M . 3. External Schema (View Level): Describes the part of the database that is visible to specific user groups. This level consists of various Views . Thus, III matches L . Therefore, the correct matching is I - N, II - M, III - L.

Continue learning with Success Tracker

Use Success Tracker to ask about the reasoning, then try another GATE CS question to check your understanding.

AI-powered practice· Unlimited practice on eligible plans

PYQs with solutions: Attempt available previous-year questions, then compare your reasoning with the worked solution. Coverage varies by stream.
Practice that adapts: Choose a topic, work on weaker areas and bookmark questions to revisit. Your attempts feed your progress tracking.
AI doubt support: Ask follow-up questions about a step or concept while practising, instead of stopping at the final answer.

Unlimited practice is available on eligible plans. Free practice and AI usage have limits; check the current plan allowances before choosing.

This page stays readable without an account. AI responses can be wrong; check them against the solution and source material.