SQL Database Concepts Question:
Download Job Interview Questions and Answers PDF
Tell me what is the order in which the SQL query is executed?
Answer:
The following is the order of executing SQL query:
The query goes to the shared pool that has information like parse tree and execution plan for the corresponding statement.
Then validates the SQL statement and validates the source(table).
Acquire locks.
Checks all the privileges.
Execute the query.
Fetch the values for SELECT statement
Displays the fetched values.
To sum up, the sequence is:
SELECT .........
FROM ..........
WHERE ..........
GROUP BY ...........
HAVING .............
The query goes to the shared pool that has information like parse tree and execution plan for the corresponding statement.
Then validates the SQL statement and validates the source(table).
Acquire locks.
Checks all the privileges.
Execute the query.
Fetch the values for SELECT statement
Displays the fetched values.
To sum up, the sequence is:
SELECT .........
FROM ..........
WHERE ..........
GROUP BY ...........
HAVING .............
Download Basic SQL Server Interview Questions And Answers
PDF
| Previous Question | Next Question |
| How to store pdf file in sql server? | Do you know concepts and capabilities of SQL Server? |