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 |
Is record in pl sql?
How global cursor can be declare with dynamic trigger ?
What does plv msg allows you to do?
Can you select everything, but 1 or 2 fields, without writer's cramp?
Mention what plvcmt and plvrb does in pl/sql?
Which language is used in sql?
What is sql prepared statement?
What is the use of a view in sql?
Can we insert data into view?
how to calcuate the second highest salary of he employee
What is not equal in sql?
how to enter numeric values as hex numbers? : Sql dba
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)