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:
Identify metadata examples: table/column definitions, primary/foreign keys, index specifications. Confirm that these are stored in system catalogs inside the database, not only in external documents. Therefore, the database "describes itself"—it contains structured descriptions of its own structure.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