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?

Difficulty: Easy

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

Discussion & Comments

No comments yet. Be the first to comment!
Join Discussion