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

Options

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

Correct Answer (Detailed Explanation is Below)

B. Data dictionary

Detailed Explanation

  • Data dictionary: Stores metadata about database objects.
  • It contains table names, column names, data types, constraints and other definitions.
  • It helps the DBMS manage and understand the database structure.