Which DBMS component is responsible for parsing and validating SQL queries?

Options

  • A. Query processor
  • B. Storage manager
  • C. Buffer manager
  • D. More than one of the above
  • E. None of the above

Correct Answer (Detailed Explanation is Below)

A. Query processor

Detailed Explanation

  • Query processor: Processes SQL queries submitted to the DBMS.
  • It performs parsing, validation, optimization and query execution coordination.
  • The query processor helps convert SQL statements into an executable form.