Which database component stores information about tables, columns and constraints?

Options

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

Correct Answer (Detailed Explanation is Below)

A. Data dictionary

Detailed Explanation

  • Data dictionary: Stores metadata about database objects.
  • It contains information about tables, columns, data types, constraints and users.
  • It is also commonly associated with the system catalog.