top button
Flag Notify
    Connect to us
      Facebook Login
      Site Registration Why to Join

Facebook Login
Site Registration

What is the difference between Transaction and a Query?

+1 vote
229 views
What is the difference between Transaction and a Query?
posted Aug 4, 2015 by Suchithra

Share this question
Facebook Share Button Twitter Share Button Google+ Share Button LinkedIn Share Button Multiple Social Share Button

1 Answer

+1 vote

A query is a single statement in SQL's data manipulation language: typically one of SELECT, INSERT, UPDATE or DELETE (the latter three may modify data, while SELECT only reads data).

A transaction is a group of statements which taken together, are usually defined to have "ACID" semantics (my own off the cuff definitions are below, but these are defined in any web or paper reference to relational database):

  • Atomicity (all statements in the transaction are executed, or none)

  • Consistency (the database is never viewable in an inconsistent state)

  • Isolation (a transaction does not affect other transactions)

  • List item Durable (once committed, the changes in the transaction are permanent)

answer Aug 5, 2015 by Shivaranjini
Similar Questions
+2 votes

Below is the one of the interview question which was held by Oracle

If a transaction is very large, and the rollback segment is not able to hold the rollback information, then will the transaction span across different rollback segments or will it terminate?

Contact Us
+91 9880187415
sales@queryhome.net
support@queryhome.net
#280, 3rd floor, 5th Main
6th Sector, HSR Layout
Bangalore-560102
Karnataka INDIA.
QUERY HOME
...