In data classification, which of the following is a typical example of structured data commonly stored in relational databases?

Difficulty: Easy

Correct Answer: Dates

Explanation:

Introduction / Context:Data is often categorized as structured, semi-structured, or unstructured. Relational databases excel at storing structured data that fits predefined schemas and data types, enabling efficient querying and constraints.

Given Data / Assumptions:

  • Structured data conforms to fixed columns and data types.
  • Unstructured data includes media like images and videos.
  • We are comparing examples that either fit or do not fit fixed schemas.

Concept / Approach:Dates are classic structured data: they have standardized formats, clear validation, and indexing possibilities. They support comparisons, ranges, and arithmetic (e.g., date difference) in SQL.

Step-by-Step Solution:

Identify which option naturally maps to a typed column (e.g., DATE).Reject media types that are typically unstructured or stored as large objects.Select “Dates” as structured data.

Verification / Alternative check:SQL dialects have native DATE/DATETIME types with constraints, functions, and indexes, confirming structured nature.

Why Other Options Are Wrong:Photo image and video clip are unstructured (or at best semi-structured via metadata). None of the above is incorrect because dates are valid structured data.

Common Pitfalls:Confusing storage method (e.g., storing a file path) with data classification; the media itself is unstructured even if referenced structurally.

Final Answer:Dates

Discussion & Comments

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