Interested to Buy Any Domain ? << Click Here >> for more details...
When we give SELECT * FROM EMP; How does oracle respond?
- 24 Answers
- 56981 Views
- Accenture, HCL, Infosys, I also Faced
- E-Mail Answers
Answer Posted / wasim
User Level Process sends the query to Server level process
where in the query gets checked syntactically first. If the
syntax is correct then the query will get break down into
parts to evaluate what has to be done.
Oracle Engine then parses the query and understands that all
the rows from employee table has to be retrieved, before the
statement execution it will check whether the data is
available already in SGA. If its available then its will
send output to user, else it will execute the statement and
fetch the output from database and store it in database
buffers and then will pass on to user.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain the components of sql?
How many functions are there in sql?
What is scalar function in sql?
What is sql scripting?
What is a heap in sql?
how can you create an empty table from an existing table? : Sql dba
How to combine two stored procedures in sql?
What is sql engine in oracle?
What does subquery mean in sql?
Which one is better subquery or joins?
What is the difference between microsoft sql and mysql?
what is text? : Sql dba
What is multiple partition?
what is an index? : Sql dba
How many sql statements are used?
