chandu77

 Profile Answers by chandu77 

• Mar 17th, 2008

 

Accessing data from a database depends on its implementation.
consider the follwing statement select empname from emp where empid=100;(Oracle)

1:first the server process of oracle checks whether the data is present in the db
buffer cache
2:if not the server process will retrieve the same from the data files and load them into
the database buffer cache

note:data will be read always in blocks...not as a single row

3:upon getting the required data into the database buffer cache,query executes
4:results are sent back to the user process