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 are the triggers associated with image items?
Mention what are different methods to trace the pl/sql code?
PL/SQL allocates memory for the variable's at runtime or at compile time
What is localdb mssqllocaldb?
How many databases can sql express handle?
Can we call a function containing dml statements in a select query?
what is self join and what is the requirement of self join? : Sql dba
Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.
What is pl sql quora?
Why do we need a foreign key?
What does rownum mean in sql?
What is integrity in 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)