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
- 11816 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
Any one plz send me SQL Server Developer/DBA resume for 4 years experience
What is transaction server auto commit?
‘Order by’ is not allowed in a view how can you sort information from a view?
What are relationships and mention different types of relationships in the dbms
What do you understand by triggers and mention the different types of it?
what types of replication are supported in sql server? : Sql server database administration
what is bit datatype and what's the information that can be stored inside a bit column? : Sql server database administration
Tell me what is fill factor?
Which data types generate inaccurate results if used with an = or <> comparison in a where clause of a sql statement?
Is sql server difficult to learn?
What is the syntax for encrypting a column in SQL Server?
Can you get second highest salary from the table?
Why is sql server log file full?
What languages bi uses to achieve the goal?
When columns are added to existing tables, what do they initially contain?
