Interested to Buy Any Domain ? << Click Here >> for more details...
When we give SELECT * FROM EMP; How does oracle respond?
- 24 Answers
- 56907 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 sqlca in db2?
Does a primary key have to be a number?
Can we join 3 tables in sql?
Is primary key clustered index?
Is sqlite thread safe?
What is sqlexception in java?
How can we implement rollback or commit statement in a trigger?
Is sql an operating system?
Can we join tables without foreign key?
how would you enter characters as hex numbers? : Sql dba
What is $$ in sql?
what is the stuff function and how does it differ from the replace function? : Sql dba
what are the 'mysql' command line arguments? : Sql dba
What is sql partition?
Is it possible to update views?
