Answer Posted / 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 View All Answers
Hi my program is accesing data from two db2 databases.what is the bind card for this program to genarate plan? how to specify the two owners and two qualifiers in bind card
How can you fix a poorly performing query?
How to read and create .LDC data files which are used by linguatic dictionary.
How to combine two function together?
Explain about xml databases?
If a column is an image value type, how you can compare column values? How can you use this column in join clause?
You have two tables with a one to many join based on a field named id. You need to find records in the parent table that are not represented in the child table. how would you accomplish this?
What you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?
How can you log an error to the server event log from a stored procedure?
What are the key features of dbms?
How to generate OIDS
How to replace not in with not exist?
I HAVE A PI ON COL A THE NEXT DAY I WANT CHANGE THE PI ON COL B? PLS SEND ME THE ANS
Who are naive users?
Write the fastest query to find out how many rows exist in a table?
