Question
Explain various types of SQL Server transactions. I.e. Explicit, Autocommit and Implicit Transactions.
Answers
Explicit transaction
A transaction which has START and END defined explicitly. The explicit transaction mode lasts until the transaction is over. When the transaction is over, the transaction is reverted back to the mode in which it started. This mode could either be implicit or autocommit.

Autocommit transactions
This is the default mode of transaction. In this mode, if the transaction is completed successfully, it is committed. If the transaction faces any error, it is rolled back.

Implicit transactions
In this mode, a new transaction is started when the current is committed or rolled back. Nothing is done to begin a transaction. One only needs to commit or roll back a transaction. Implicit transactions have a chain of continuous transactions.   Your Comment




  • Contributors: *,
More Software Questions..
What is the inputsplit in map reduce software?
What is software configuration management?
What Is Java Api For Xml-based Rpc (jax-rpc)?
How can you implement fine-grained auditing?
What is IBM’s simple explanation for Big Data’s four critical features?
What is static synchronized method in JDBC API? Give an example?
What does the NULLIF function do?
What happens if a start method is not invoked and the run method is directly invoked?
Should we override finalize method
what is the difference between mysql_fetch_array and mysql_fetch_object?
How will XML affect my document links?
Why to use Style Sheets?
What are Filters in MVC?
Can you explain Application layer in OSI model?
How to define new testplan attributes?
What are the minimum system requirements to run Photoshop? Is it possible to run Photoshop over linux?
Which oracle package is used to manage the oracle lock management services?
What is Latch Up? Explain Latch Up with cross section of a CMOS Inverter. How do you avoid Latch Up?
What is marker interface?
What types of partitioning are there for BW?


Search
Can you Answer!!
  • Q How would add new Facebook members to the database of members, and code their relationships to others in the database?
  • Q Sheikh Zayed Stadium?
  • Q Who translated Tagore's 'Gitanjali’ for the first time into Malayalam?
  • Q How do you list all databases whose name starts with p?
  • Q What are the three type of routing tables and what are the advantages and disadvantages of these?
  • Q Is pollution always caused by humans?
  • Q What is an EnableViewState in ASP.Net?
  • Q Is there a command to check the advertised routes along with the prepend of the AS-paths?
  • Q What are the main mineral salts responsible for the cellular osmotic regulation?
  • Q How do I do < fill-in-the-blank > for each element in an array?
  • Q What is the popular name of the ITF World Mixed Team Championship ?