In a relational database, which metadata specifies the permitted values and type of a column?

Options

  • A. Data definition
  • B. Transaction log
  • C. Query result
  • D. More than one of the above
  • E. None of the above

Correct Answer (Detailed Explanation is Below)

A. Data definition

Detailed Explanation

  • Data definition: Defines the structure and properties of database columns.
  • Data types such as INTEGER, VARCHAR and DATE specify the kinds of values a column can store.
  • Constraints can further restrict permitted values.