top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

What is the difference between Transaction and a Query?

+1 vote
1,271 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 LinkedIn 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?

...