RDBMS - If we have a table which is accessed by multiple users and two or more user's are simultaniously try

GeekInterview.com > Tech FAQs > RDBMS

Go To First | Previous Question | Next Question

RDBMS | Question 13 of 18

If we have a table which is accessed by multiple users and two or more user's are simultaniously trying to modify the table. Then what happens and how can we manage such situations?

Total Answers and Comments: 3

Last Update: July 13, 2007 Asked by: techmind

Sponsored Links

Best Rated Answer

—

Submitted by: Gajanan

There are two ways of changing the rows in particular table.
One to delete the row
Second to modify/Change the data of row in table.
In every case we opt for exclusive locks

So when one user has exclusive lock then another user can’t share that information unless first user releases that locks.

Another type of lock is shared lock, which is used when two or more users share the same information for reading purpose (No change in the database).

Above answer was rated as good by the following members:
gvmahesh

December 07, 2006 09:58:22

praveen

RE: If we have a table which is accessed by multiple u...

if one user is going to modify the table he will be aquired lock on that particular row of that table and it will be released to the other user whose is trying ot modify the same table after the modifications are commited by the first user. or else we can handle the situations using no wait option

Is this answer useful? Yes | No

December 07, 2006 15:47:08

techmind

RE: If we have a table which is accessed by multiple u...

Could you please elaborate how can we do it with no wait option.

Is this answer useful? Yes | No

July 13, 2007 03:44:17

Gajanan

RE: If we have a table which is accessed by multiple u...

There are two ways of changing the rows in particular table.
One to delete the row
Second to modify/Change the data of row in table.
In every case we opt for exclusive locks

So when one user has exclusive lock then another user can’t share that information unless first user releases that locks.

Another type of lock is shared lock which is used when two or more users share the same information for reading purpose (No change in the database).

Is this answer useful? Yes | No

1 0

Overall Rating: +1

Go To Top

User Name		Remember Me?
Password

Question Bank