Computer Sciences > GATE 2026 SET-2 > Database Management System
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?
A
I-L, II-M, III-N
B
I-M, II-L, III-N
C
I-N, II-M, III-L
D
I-N, II-L, III-M

Correct : c

I: Logical schema → N: Relations
The logical schema describes the overall structure of the database in terms of relations (tables), attributes, constraints and their relationships. It is what the DBA sees and works with. Relations belong to the logical level.
II: Physical schema → M: File organization and indexes
The physical schema describes how data is actually stored on disk — file organization, indexing structures, access paths, storage details. This is the lowest level dealing with physical storage.
III: External schema → L: Views
The external schema (also called user views or subschema) defines how different users or applications see the data. Each user gets a customized view — hiding parts of the logical schema they don''t need. Views belong to the external level.
So the correct mapping is I-N, II-M, III-L → Option C.

Similar Questions

In a database system, unique time stamps are assigned to each transaction using Lamport’s logical clock. Let TS(T1) and TS(T2) be the time stamps of transaction...
#176 MCQ
Consider concurrent execution of two transactions T1 and T2 in a DBMS, both of which access a data object A. For these two transactions to not conflict on A, wh...
#1565 MCQ
In the context of schema normalization in relational DBMS, consider a set F of functional dependencies. The set of all functional dependencies implied by F is...
#1587 MCQ

Related Topics

DBMS three schema architecture GATE 2026 GATE CS 2026 Set-2 Q15 logical schema relations GATE physical schema file organization indexes GATE external schema views GATE DBMS schema levels GATE 2026 conceptual physical external schema DBMS

Unique Visitor Count

Total Unique Visitors

Loading......