Which DBMS facility maintains information about tables, columns, constraints and other database objects?

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 and constraints.
  • Metadata means data about data.