What are explicit and implicit transactions?
Answer Posted / anton
Implicit transactions are used automatically ACID
properties,mean would be updated or none of them would.
Explicit transactions are started by using the BEGIN
TRANSACTION T-SQL command and are stopped by using the
COMMIT TRANSACTION or ROLLBACK TRANSACTION commands.
Is This Answer Correct ? | 3 Yes | 3 No |
Post New Answer View All Answers
Explain about builtinadministrator?
Describe in brief databases and sql server databases architecture.
What are page splits?
Define right outer join?
Difference between DELETE and TRUNCATE?
What are the differences between union, intersect, and minus operators?
What do you mean by data integrity?
How to reaname table name without using sp_Rename in sql server..?
Can you explain the disadvantages/limitation of the cursor?
How do you use a subquery to find records that exist in one table and do not exist in another?
Explain optimistic and pessimistic concurrency?
Explain can you implement data mining in ssrs?
How do I know if localdb is running?
A trigger can reference objects outside the current database? State true or false.
How to enable/disable indexes?