Question

Select the sequence for how the query mechanism works?

(a) Authentication-> DDL->DML->query optimizer->output

(b) DDL->DML->query optimizer-> Authentication->output

(c) DML->query optimizer-> Authentication-> DDL-> output

(d) All of the mentioned

This question was posed to me in my homework.

This interesting question is from Query Mechanics topic in section Query Optimization of MySQL

Answer 1

Right answer is (a) Authentication-> DDL->DML->query optimizer->output

Best explanation: When we execute any query, the first step is authentication (password). Second step for data definition mechanism, the third step is for Data Manipulation and the last is optimizer for efficient execution.