Interested to Buy Any Domain ? << Click Here >> for more details...
When we give SELECT * FROM EMP; How does oracle respond?
- 24 Answers
- 58674 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 row? : Sql dba
What are sql functions? Describe the different types of sql functions?
What does sign mean sql?
Is it mandatory for the primary key to be given a value when a new record is inserted?
Explain the working of primary key?
What is dba in sql? : SQL DBA
What is multiple columns?
How do I count rows in sql?
What are %type and %rowtype for?
What are the different types of dbms?
What is the maximum rows in csv?
What is the use of double ampersand (&&) in sql queries? Give an example
What are sql commands?
what is a constraint? : Sql dba
What are the advantages of normalization?
