If there is failure during updation of certain rows, what
will be the state?
Answer Posted / guest
No changes will occur. So the data will be in previous
state only.
| Is This Answer Correct ? | 18 Yes | 0 No |
Post New Answer View All Answers
Explain comment on transactions?
Can you explain different types of locks in sql server?
What do you mean by an execution plan? Why is it used?
Differentiate between a local and a global temporary table?
How to create a view on an existing table in ms sql server?
Can you pass expressions to stored procedure parameters?
Can we shrink data file in sql server?
What is query optimization process?
Explain different types of Normalization.
what is denormalization? : Sql server database administration
What are subqueries in sql server?
What is blocking and how would you troubleshoot it? : sql server database administration
Can you name a few encryption mechanisms in sql server?
What are the disadvantages of primary key and foreign key in SQL?
What is the command dbcc checkdb used for?