Interested to Buy Any Domain ? << Click Here >> for more details...
When we give SELECT * FROM EMP; How does oracle respond?
- 24 Answers
- 58726 Views
- Accenture, HCL, Infosys, I also Faced
- E-Mail Answers
Answer Posted / venky
when we fire this query on
first it will send to sql buffer
then sql buffer send to SGA
sGA send to sql*plus layer
this layer interact with the database server if the table
is exist in the database server , it will dispatch the all
rows to sql*plus layer
from this layer to SGA-----> output buffer
..
finally it wii display on the location of interface(screen)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what are the limitations of identity column? : Transact sql
What is a data manipulation language?
What are the various restrictions imposed on view in terms of dml?
What does stand for in sql?
What is sql stand for?
what are the properties and different types of sub-queries? : Sql dba
Where the sql database files are stored?
Is sql the best database?
How do you truncate?
What is the difference between a primary key and a clustered index?
What is sql architecture?
What is a primary key called that is made up of more than one field?
What is meant by cursor in sql?
Does sql between include endpoints?
What does closing a cursor do?
