INTERVIEW QUESTIONS DATABASE SQL DETAILS

Question: Whats the back end processes when we type "Select * from Table"?

Answer: First it will look into the System Global Area (SGA) weather the query is been exectued earlier.

If it exist, it would retrive the same output present in memory.

If not the query we typed is complied and the resulting parse tree and excution plan is been stored in SGA. Then query gets executed and output is given to the application.

First it will look into the System Global Area (SGA) weather the query is been exectued earlier.

If it exist, it would retrive the same output present in memory.

If not the query we typed is complied and the resulting parse tree and excution plan is been stored in SGA. Then query gets executed and output is given to the application.

Source: CoolInterview.com

If you have the better answer, then send it to us. We will display your answer after the approval.

Rules to Post Answers in CoolInterview.com:-

• There should not be any Spelling Mistakes.
• There should not be any Gramatical Errors.
• Answers must not contain any bad words.
• Answers should not be the repeat of same answer, already approved.
• Answer should be complete in itself.

Name :*
Email Id :*
Answer :*
Verification Code	Not readable? Load New Code
Enter the above shown code: *
	Inform me about updated answers to this question