ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage   interview questions urls   External Links  Contact Us     Login  |  Sign Up                      
info       Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff   HERE
Google
 
Categories  >>  Software  >>  Microsoft Related  >>  ADO.NET
 
 


 

 
 Visual Basic interview questions  Visual Basic Interview Questions
 C Sharp interview questions  C Sharp Interview Questions
 ASP.NET interview questions  ASP.NET Interview Questions
 VB.NET interview questions  VB.NET Interview Questions
 COM+ interview questions  COM+ Interview Questions
 ADO.NET interview questions  ADO.NET Interview Questions
 IIS interview questions  IIS Interview Questions
 MTS interview questions  MTS Interview Questions
 Crystal Reports interview questions  Crystal Reports Interview Questions
 BizTalk interview questions  BizTalk Interview Questions
 Dot Net interview questions  Dot Net Interview Questions
 Exchange Server interview questions  Exchange Server Interview Questions
 Microsoft Related AllOther interview questions  Microsoft Related AllOther Interview Questions
Question
When multiple users attempt to modify data at the same time
Ex user 1 is updating record at same time user2 deleted
record  sucessfully.now user1 has press update button . how
to handle concurrency
 Question Submitted By :: Guest
I also faced this Question!!     Rank Answer Posted By  
 
  Re: When multiple users attempt to modify data at the same time Ex user 1 is updating record at same time user2 deleted record sucessfully.now user1 has press update button . how to handle concurrency
Answer
# 1
Have one column with in Database table with datatype as
TimeStamp and while selecting the row we will read the
TimeStamp value, which we can compare at the time of updation, 

if both values are same then we can update that row
otherwise we can resist the user from updating saying that
someone has updated the row, you can't update it.
 
Is This Answer Correct ?    3 Yes 0 No
Umar Topia
 
  Re: When multiple users attempt to modify data at the same time Ex user 1 is updating record at same time user2 deleted record sucessfully.now user1 has press update button . how to handle concurrency
Answer
# 2
You can use one primary key and one timestamp field to sort
out the problem of concurrency. 
The steps are like this
1.Fetch the record from database and store the primary key
value and timestamp in the session.
2.Update the same record with new values other fields using
the same session values for primary key and timestamp fields.
 
Is This Answer Correct ?    1 Yes 0 No
KiranMadiraju
[Capgemini]
 
 
 
  Re: When multiple users attempt to modify data at the same time Ex user 1 is updating record at same time user2 deleted record sucessfully.now user1 has press update button . how to handle concurrency
Answer
# 3
we can have to use exclusive locks on the table thats why 
we can't change data at a time..
 
Is This Answer Correct ?    1 Yes 0 No
Shweta
 

 
 
 
Other ADO.NET Interview Questions
 
  Question Asked @ Answers
 
What does ADO.NET consists of ? TCS5
Advantage of ADO.Net? TCS2
what is typed and untyped dataset  2
What happens when u try to update data in a dataset in .NET while the record is already deleted in SQL SERVER as backend?  5
How do we invoke queries from the application ? Microsoft1
What happens when we issue Dataset.ReadXml command?  1
What provider ADO.net use by default? Accenture5
Where do you store connection string ? Digital-GlobalSoft1
Difference between DataReader and DataAdapter / DataSet and DataAdapter? TCS2
What is the key feature of ADO.NET compared to ADO ? TCS2
What is the provider and namespaces being used to access oracle database? Microsoft2
Which method do you invoke on the DataAdapter control to load your generated dataset with data?  3
what is clustered index?why is it created? Microsoft3
Difference between datareader and dataset? Microsoft9
What is @@rowcount and with small code snippet explain the usage? BirlaSoft4
Difference between ADO and ADO.net ? Accenture5
Explain what a diffgram is and its usage ?  1
what is bubbled event can u pls explain Wipro2
make a login control??  1
If i am expecting a single result from sqlserverdatabase then what command should i follow ?sqlcommand.executereader (commandbehaviour.singleresult)or sqlcommand.executescalar()  4
 
For more ADO.NET Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com