What is a transaction?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are sql procedures?

667


What is partition in sql query?

609


How many types of functions are there in sql?

584


How to use sql*plus built-in timers?

666


Is it possible to sort a column using a column alias?

693






how to include character strings in sql statements? : Sql dba

626


how to enter binary numbers in sql statements? : Sql dba

586


What is on delete set null?

654


What is the usage of the distinct keyword?

794


how to return query output in html format? : Sql dba

746


Differentiate between sga and pga.

787


What is the use of double ampersand (&&) in sql queries? Give an example

707


difference between anonymous blocks and sub-programs.

718


What is the use of index in sql?

661


- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?

1484