August 29, 2007 at 10:43 am
Dear Experts,
I have faced the below question in an interview.
------------------------------------------------------------
If there is failure during updation of certain rows, what will be the state ?
------------------------------------------------------------
Inputs are welcome !
Regards
Karthik
karthik
August 29, 2007 at 11:00 am
If the transaction didn't commit it will be rolled back.
August 30, 2007 at 7:00 am
State? Not sure the interviewer knew the answer either. I would ask for clairification on the point.
Error state? Message? Data integrity?
Data would be the same as it was before the update started (possibly). Depending on the statement data NOT locked by the update could have been changed by other sessions.
Any rows that were successfully updated before the failure would however be rolled back after the failure. (I suspect that is what they were looking for)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply