Interested to Buy Any Domain ? << Click Here >> for more details...
What is the order in which the SQL query is executed? list
them in order.
- 5 Answers
- 11787 Views
- CarrizalSoft Technologies, CTS, Oracle, I also Faced
- E-Mail Answers
Answer Posted / l. meher
When a SQL query is getting executed it goes through the
following steps:
1) It goes to the shared pool which contains information
such as the parse tree and execution plan for the
corresponding statement.
2)Validate the SQL statement.
3)Validate the source.
4)Acquire locks.
5)Checks for previllages.
6)Parse the statement.
7)Execute the Query.
8)Fetch the value (only for select statement).
9)Generate the redo information.
If you have any doubt mail me at lmeher.tcs@gmail.com
Thanks..
| Is This Answer Correct ? | 5 Yes | 4 No |
Post New Answer View All Answers
what are acid properties? : Sql server database administration
Explain intellisense for query editing
In what version of sql server were synonyms released?
In which tcp/ip port does sql server run? Can it be changed?
What are distinctive joins find as a part of sql?
What do you mean by the term 'normalization'?
how would you store your query in an SSRS report or a Database server?
How will you optimize a stored procedure optimization?
What Is Rdbms?
What methods do you follow to protect from sql injection attack?
Explain few examples of RDBMS?
Explain about builtinadministrator?
Why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it?
How we can compare two database data?
What are entities and relationships?
