Hai all,

I am new to programming. I never been into multiuser system programming.

In one of my interview, they asked me like.........

There is a table with order details.......like order no (auto increment field),order detail. If there are multi users in the system. If one user is accessing orderno 1001 and their details,,,and the another user is also accessing same orderno 1001 at the same time.........user1 is updating the record and storing it back................but still user2 is using the odd records only ..........how do you overcome this problem.........(in interview they asked me like this........

Please tell answer in detail.................

the user2 will still access the old data till the user1 executes COMMIT.
To avoid this user need to lock the table / record before executing any UPDATE command.