1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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?..

Answer / lu

The data will rollback

Is This Answer Correct ?    6 Yes 0 No

Post New Answer

More SQL Server Interview Questions

What is the function of inner join?

0 Answers  

What does it mean to be in union?

0 Answers  

do views contain data ?

0 Answers   MCN Solutions,

What stored by the msdb?

0 Answers  

How to get a list all databases on the sql server?

0 Answers  




Can the query output be sorted by multiple columns in ms sql server?

0 Answers  

Can select statements be used on views in ms sql server?

0 Answers  

What is the system function to get the current user's user id?

3 Answers   TCS,

What is sub-query in sql server? Explain its properties.

0 Answers  

Can we create SP inside SP ? If no Y ? If yes Y ? Explain with an example ?

3 Answers   IBM, L&T,

What are differences in between sql server 2012 and sql server 2016?

0 Answers  

Introduction of rollup clause using sum and group by clause?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories