Difficulty: Easy
Correct Answer: Correct
Explanation:
Introduction / Context:
The term "self-describing" highlights a defining feature of modern DBMSs: metadata (data about data) stored within the database. This question probes whether you recognize catalogs/dictionaries as first-class parts of database systems.
Given Data / Assumptions:
Concept / Approach:
A database is self-describing because its schema and related metadata are themselves stored as data that can be queried, secured, and managed. For example, INFORMATION_SCHEMA views in SQL standards or vendor-specific system tables expose definitions and constraints, making the system introspective and consistent.
Step-by-Step Solution:
Verification / Alternative check:
Run queries like SELECT * FROM INFORMATION_SCHEMA.COLUMNS (or vendor equivalents) to retrieve column metadata; observe that results live inside the DBMS itself.
Why Other Options Are Wrong:
Common Pitfalls:
Confusing documentation (external) with metadata (internal). Assuming schemas exist only in DDL scripts; in reality, the DBMS persists and exposes them as data.
Final Answer:
Correct
Discussion & Comments