Interested to Buy Any Domain ? << Click Here >> for more details...
When we give SELECT * FROM EMP; How does oracle respond?
- 24 Answers
- 57873 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
what is the difference between primary key and unique key? : Sql dba
what is not null constraint? : Sql dba
What is dbo in sql?
what is oltp (online transaction processing)? : Sql dba
What is the largest value that can be stored in a byte data field?
Is id a reserved word in sql?
What is a temporal table?
How do you change a value in sql?
What is set serveroutput on in pl sql?
What are the set operators in sql?
How to prepare for oracle pl sql certification?
Can you sum a count in sql?
What are the types of records?
what is the difference between sql and t-sql? : Transact sql
What is left join example?
