Multiple choice

Which of the following DBMS software modules verify parse queries, DML retrieval statements and database update statements and also check the catalog to verify whether all the schema names referenced in these statements are valid?

  1. DDL compilers

  2. Query and DML compilers

  3. Query and DML optimiser

  4. Authorisation and security checking

  5. Query and DML parser
Reveal answer Fill a bubble to check yourself
E Correct answer
Explanation

Query and DML parser verify parse queries, DML retrieval statements and database update statements and also check the catalog to verify whether all the schema names referenced in these statements are valid.

Keep practicing — related questions