Interesting query

Suppose one user1 issues a select statement on a table 'temp' at 11:00 and his search continues till 11:10, simultaneously another user2 updates the same table 'temp' at 11:01 and commits it at 11:05, now what is the result of the query of user1 which completes at 11:10, will he get the updated data or the old one, why???

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Thu Jun 03 1999 - 14:18:32 CDT