What is the order in which the SQL query is executed? list
them in order.
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
How do you Implement SSIS Packages in your Project?
How to drop existing indexes in ms sql server?
What is the difference between mysql and sql server?
Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many
How to use union to merge outputs from two queries together in ms sql server?
What are different types of replication in sql server?
How to convert numeric values to integers in ms sql server?
What are the joins in sql server? : sql server database administration
What is the command dbcc checkdb used for?
Differentiate between SQL and ORACLE joins and write their syntax.
Explain the different types of backups available in sql server? : sql server database administration
What is ms sql server service broker?
Why do we use stored procedures in sql server?
How does stuff differ from the replace function?
Do you know what are acid properties of transaction?