Technical - SQL Update

GeekInterview.com > Placement Papers > Accenture > Technical

Go To First | Previous Question |

Technical | Question 31 of 31

SQL Update

can two persons update the same row at same time.if it is possible how?

Total Answers and Comments: 4

Last Update: July 09, 2009 Asked by: sasi_akkala

Sponsored Links

Best Rated Answer

—

Submitted by: rajani_vaddepalli15

yes..we can!
because,the updations take place on the secondary storage(database) with difference between microseconds or nanoseconds!

Above answer was rated as good by the following members:
phaniraj baggolli

June 30, 2008 03:33:54

rajani_vaddepalli15

Member Since: June 2008 Contribution: 19

RE: SQL Update

yes..we can!
because the updations take place on the secondary storage(database) with difference between microseconds or nanoseconds!

Is this answer useful? Yes | No

1 0

Overall Rating: +1

August 08, 2008 18:29:50

kishorehhappy

Member Since: March 2007 Contribution: 1

RE: SQL Update

No it is not possible to update same row by two different persons

Is this answer useful? Yes | No

January 28, 2009 03:38:40

oz_girl

Member Since: January 2009 Contribution: 1

RE: SQL Update

Locking and row versioning prevent users from reading uncommitted data and prevent multiple users from attempting to change the same data at the same time.

Is this answer useful? Yes | No

July 09, 2009 01:13:45

bk_karthi

Member Since: July 2009 Contribution: 1

RE: SQL Update

Yes.
We can update by using COMMIT UNCOMMIT methods. Second record cannot update till the first record is committed.

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank