When we give SELECT * FROM EMP; How does oracle respond?
- 24 Answers
- 53601 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
How do I run a query in pl sql developer?
How do you optimize a stored procedure in sql?
Is sql harder than python?
What is hibernate and its relation to sql?
What are stored procedures in mysql?
What is dcl in sql?
What is data control language (dcl)?
what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?
What is the most important ddl statements in sql are?
What is partition by in sql?
Why do we need sharding?
Why functions are used in sql?
When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?
explain the advantages and disadvantages of stored procedure? : Sql dba
How many sectors are in a partition?
