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 |
What is the basic form of sql query?
What is sql performance tuning?
What is mutating trigger?How to avoid it??
how will u find statistics of a database objects?
What is the difference between mdf and ndf files?
Why do we use %rowtype & %type in plsql?
What is Primary Key?
How to make a copy values from one column to another in sql?
What is auto increment in sql?
What is a boolean in sql?
What are the main features of cursor?
what is the order of pre-defined exceptions.