Difficulty: Easy
Correct Answer: Correct
Explanation:
Introduction / Context:
Accurate terms matter in database design. The accepted term for a central store of metadata is repository or data dictionary, not “depository.” This question verifies that you recognize the correct terminology and concept.
Given Data / Assumptions:
Concept / Approach:
System catalogs and enterprise repositories centralize metadata for governance and tooling (lineage, impact analysis, code generation). The term “depository” is not standard in this context. Hence, saying “depository” is incorrect; “repository” (or “data dictionary”) is correct.
Step-by-Step Solution:
Verification / Alternative check:
Check DBMS documentation (e.g., INFORMATION_SCHEMA, system catalogs). Modeling tools likewise advertise “metadata repositories.”
Why Other Options Are Wrong:
Common Pitfalls:
Confusing repository with data warehouse; thinking metadata live only in ERD files rather than in DBMS catalogs.
Final Answer:
Correct
Discussion & Comments