What will be the ordering of typical steps when processing a high-level query?
A. Query optimizer
B. Runtime database processor
C. Scanning, parsing and validating
D. Query code generator
🎥 Video solution / Text Solution of this question is given below:
Typical DBMS query processing steps:
Scanning, parsing and validating → C
Query optimizer → A
Query code generator → D
Runtime database processor → B
Correct order:
C → A → D → B