What is a transaction?
Answers were Sorted based on User's Feedback
Answer / reddibasha
Transaction is a Set of DML operations with Commit /
Rollback. In SQL, transaction starts with DML command
(Except SELECT) and ends with Commit / Rollback(Implicit /
Explicit).
Is This Answer Correct ? | 4 Yes | 0 No |
Answer / pavan_1981
set of related dml operations to perform a task are called
a transaction.
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / dawood
It starts with a first executable statement and ends when
commit or rollback statement occurs.
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / aravind
Transaction is a logical unit of work that comprises of one
or more sql statements.
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / ashok
All the DML operations between two COMMIT points can be called as a Transaction and Oracle server handles this as a single unit
Is This Answer Correct ? | 0 Yes | 0 No |
Why do we need unique key in a table?
How many rows can sqlite handle?
What are sql queries used for?
What are operators available in sql?
What are the basic sql commands?
What is difference between cursor and trigger?
Is sql a programming?
Why do we need databases?
How do you declare a user-defined exception?
What jobs use sql?
What is pl sql code?
What are sql triggers used for?