Can you have a nested transaction?



Can you have a nested transaction?..

Answer / abinash

yes we can have nested transaction.

A transaction is nothing a set of sql statement which either executes at a time or nothing will happen and we specify the transaction using Begin and End.

And also we can have multiple begin end (nested transaction) inside a transaction.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More DB Development Interview Questions

What are the disadvantages of cursors? How can you avoid cursors?

2 Answers  


How long can an error message be in raiseerror function?

0 Answers  


Write short notes on XSU and JAVA

1 Answers  


What is the maximum length of an extended property?

0 Answers  


What are the three basic rules which are to be followed for the relational model of the database?

0 Answers  






To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?

0 Answers  


Hi , any one can help me on the same,this is regarding the Informatica Function doc,i want to know how developer is will develop the mapping. pl forwar the any function doc .just for my references. svlc75@yahoo.co.in

0 Answers   Covansys,


Explain about relational database management systems?

0 Answers  


How you can make a parameterized view?

0 Answers  


How to customize error conditions.

0 Answers  


Explain the rollup operator?

0 Answers  


What is a self join? Explain it with an example?

16 Answers   TCS,


Categories