what is transaction? : Sql dba



what is transaction? : Sql dba..

Answer / Mohit Singh Chauhan

A transaction in SQL is a logical unit of work that contains one or more SQL statements. It ensures data integrity by guaranteeing that all the SQL statements within the transaction are executed together, committed as a whole (successfully), or rolled back (unexecuted) if any error occurs.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

What is recursive stored procedure?

1 Answers  


what is timestamp in mysql? : Sql dba

1 Answers  


What is use of package in pl sql?

1 Answers  


What is an implicit commit?

1 Answers  


Define union, minus, union all, intersect ?

1 Answers  


How do you concatenate in sql?

1 Answers  


What is the use of function "module procedure" in pl/sql?

1 Answers  


What can be a size of a pl/sql block? Is there any limit?

2 Answers  


How to select unique records from a table?

1 Answers  


what's the difference between a primary key and a unique key? : Sql dba

1 Answers  


What is case function?

1 Answers  


What is the difference between the conventional and direct path loader? : aql loader

1 Answers  


Categories