Interested to Buy Any Domain ? << Click Here >> for more details...
When we give SELECT * FROM EMP; How does oracle respond?
- 24 Answers
- 57918 Views
- Accenture, HCL, Infosys, I also Faced
- E-Mail Answers
Answer Posted / umashankar
1.The PARSER scans/reads the SELECT statement and splits it
into some logical units such.
i.e: keywords/reserved word, operators, expressions and
identifiers.
2. SEQUENCE TREE or QUERY TREE is built the logical steps
needed to transform the source data into the format as
needed by the end result.
3. The QUERY OPRIMIZER analyzes the query in various ways
and selects the series of steps that returns the end
results fastest way. The query tree is updated to record
this exact series of steps. The final, optimized version of
the query tree is called the execution plan.
4. The RELATIONAL ENGINE starts executing the execution
plan which was prepared by the Query Optimizer.
5.The RELATIONAL ENGINE requests the STORAGE ENGINE pass up
data from the rowsets requested.
6. The RELATIONAL ENGINE processes the data (returns all
column values from EMP table) returned from the storage
engine to the client.
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
What do you understand by exception handling in pl/sql?
How is data stored in sql?
Why stored procedure is faster than query?
When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?
how many values can the set function of mysql take? : Sql dba
Write a unique difference between a function and a stored procedure.
What are crud methods?
Why do we use function in pl sql?
How do you delete duplicates in sql query using rowid?
What are the different tcl commands in sql?
What is procedure explain with example?
What is the difference between a query and a report?
What is difference between function and trigger?
how many ways we can we find the current date using mysql? : Sql dba
What are few of the schema objects that are created using PL/SQL?
