In data management terminology, are data descriptions (metadata) typically stored in a central repository (data dictionary), rather than a so-called “depository”?
-
ACorrect
-
BIncorrect
-
COnly true for relational databases
-
DCannot be generalized across tools
Answer
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:
- Metadata include table/column definitions, constraints, indexes, views, users, and privileges.
- DBMSs maintain catalog tables (system catalogs) to record this information.
- Enterprise modeling tools may maintain additional metadata repositories outside the DBMS.
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:
Identify the concept: central metadata store.Recall standard terms: repository, data dictionary, system catalog.Compare with “depository”: nonstandard usage here.Conclude the original statement is false as written.Verification / Alternative check:Check DBMS documentation (e.g., INFORMATION_SCHEMA, system catalogs). Modeling tools likewise advertise “metadata repositories.”
Why Other Options Are Wrong:
- Incorrect: would accept the wrong terminology.
- Relational-only: nonrelational systems also keep metadata repositories.
- “Cannot be generalized” is weak—terminology is well-established.
Common Pitfalls:Confusing repository with data warehouse; thinking metadata live only in ERD files rather than in DBMS catalogs.
Final Answer:Correct