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 cursor status?
Can we perform dml on view?
why sql is used as interpreter frequently rather than a compile?
Is oracle sql free?
How do I run sql profiler?
Mention what does the hierarchical profiler does?
How much does sql cost?
how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba
how to add a new column to an existing table in mysql? : Sql dba
What is a parameter query?
What SQL keyword must immediately follow the UNION ALL statement? 1. SELECT 2. INTO 3. ORDER 4. WHERE 5. JOIN
What is numeric function sql?
Oracle (3253)
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)