Which level of database architecture defines the entire logical structure of the database, including entities, relationships, and constraints, independent of physical storage? MCQ with Answer and Explanation
Which level of database architecture defines the entire logical structure of the database, including entities, relationships, and constraints, independent of physical storage?
A. Physical Level
B. View Level
C. Conceptual Level
D. Internal Level
Answer: Option C
Solution (By JKSSB Mock Tests)
The Conceptual (or Logical) level describes what data is stored in the entire database and what relationships exist among those data points.
Explanation:
Databases are optimized for transaction processing (OLTP), while data warehouses are designed for analytical reporting (OLAP) using historical data.
No comments yet. Be the first to start the discussion!