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 group function in sql?
How to get second highest salary from a table
Why is sql better than hql?
What is sql scripting?
What is rtm in testing?
Why is a trigger used?
Can we join two tables without common column?
What is query optimization in sql?
What are sql ddl commands?
How to generate a salary slip like jan 1000 1000 feb 1000 2000 ... dec 1000 12000
what are the forced views
How to move files from one directory to another in pl sql?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)