17
Match List-I with List-II:
Choose the correct answer from the options given below:
|
List - I
सूची - I
Architecture Level
List-I (Architecture Level
|
List - II
सूची - II
Description
List-II (Description
|
||
|---|---|---|---|
| A | Internal level Internal level | I | Represents the overall logical structure of the entire database Represents the overall logical structure of the entire database |
| B | Conceptual level Conceptual level | II | Defines individual user views or schemas Defines individual user views or schemas |
| C | External level External level | III | Hides the physical details of the database from users Hides the physical details of the database from users |
| D | Data abstraction Data abstraction | IV | Describes how data is physically stored in the database Describes how data is physically stored in the database |
EXPLANATION
Applied Statistical Methods
- ANSI/SPARC Three-Schema Database Architecture:
- Internal Level (Physical Level) $\to$ (IV): Describes physical storage structures, data paths, indexes, and block formats on the storage media.
- Conceptual Level (Logical Level) $\to$ (I): Describes the overall logical structure and relationships of the entire database (entities, attributes, relationships, integrity constraints) for all users without physical storage details.
- External Level (View Level) $\to$ (II): Describes individual user views, schemas, or tailor-made subsets of the database presented to specific user communities.
- Data Abstraction $\to$ (III): The foundational DBMS capability of suppressing complex implementation and storage details from end-users across levels.
- Matching Result: (A) - (IV), (B) - (I), (C) - (II), (D) - (III) (Option 2).
Correct option: (2) (A) - (IV), (B) - (1), (C) - (HN), (D) - (ttl)
Explanation not matching this question?
क्या व्याख्या इस प्रश्न से मेल नहीं खा रही?
Report
Want to practice this paper in exam conditions?
क्या आप परीक्षा जैसे माहौल में अभ्यास करना चाहते हैं?
Test yourself in 5-question batch format with timer and hidden answers.
5-प्रश्नों के बैच फॉर्मैट, टाइमर और छिपे उत्तरों के साथ खुद को परखें।
Start Practice Mode →
प्रैक्टिस टेस्ट मोड शुरू करें →