If there is failure during updation of certain rows, what will be the state?

If there is failure during updation of certain rows, what
will be the state?

Question Posted / guest

Answers were Sorted based on User's Feedback

If there is failure during updation of certain rows, what will be the state?..

Answer / guest

No changes will occur. So the data will be in previous
state only.

Is This Answer Correct ?

18 Yes

0 No

If there is failure during updation of certain rows, what will be the state?..

The data will rollback

Is This Answer Correct ?

6 Yes

0 No

More SQL Server Interview Questions

How To Change Column Ordinal Position in SQL Server 2005 using Query i.e I Want To Add Column at Particular Ordinal Position in SQL Server 2005

What is a derived table?

What is the difference between deallocate cursor and close cursor?

How can you know if the row fetched from cursor is still valid in underlying table?

What is sql server agent and what are the two modes of authentication in sql server?

How to create a dml trigger using create trigger statements?

what is a transaction and what are acid properties? : Sql server database administration

What are the hotfixes and patches in sql server?

What are the properties of primary key?

Do you know data definition language, data control language and data manipulation language?

Write an sql query for deleting duplicate rows?

John exports information periodically from a microsoft sql server database to an oracle database what is the best way to do this?

For more SQL Server Interview Questions Click Here