You query a DBMS system table named USER_TABLES and get columns like 'TableName', 'NumberOfColumns', and 'PrimaryKey'. What kind of data are you looking at?
Database
Introduction to Database
Difficulty: Easy
Choose an option
-
Auser data.
-
Bmetadata
-
CA report
-
Dindexes
Answer
Correct Answer: metadata
Explanation
Introduction / Context:System catalogs (data dictionaries) describe database objects. Understanding this distinction is fundamental to administration and SQL tooling.
Given Data / Assumptions:
- Table name resembles a system/user catalog (e.g., USER_TABLES).
- Columns describe properties of tables, not business records.
Concept / Approach:Metadata is “data about data.” It includes table names, column counts, primary keys, data types, constraints, and other structural information.
Step-by-Step Reasoning:
Fields like TableName and NumberOfColumns describe structure.PrimaryKey information is also schema-level detail.Therefore, the dataset is metadata, not transactional user data.Verification / Alternative check:Compare with a typical business table (e.g., ORDERS) which stores user data like amounts and dates, not schema descriptions.
Why Other Options Are Wrong:
- User data → actual business records; not structural.
- A report → presentation format, not the nature of the data.
- Indexes → separate objects; while related, they are not the catalog view itself.
Common Pitfalls:Confusing system catalogs (metadata) with application tables.
Final Answer:metadata