Which is faster delete or truncate?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More DB2 Interview Questions

What are foreign keys?

1 Answers  


When will you chose to run RUNSTATS?

1 Answers  


How to check table size in db2 sap?

0 Answers  


How do I copy a table in db2?

0 Answers  


in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?

0 Answers  






What is copy book?

1 Answers   Thomson Reuters,


I have 3 cursors declared. Cursor1 retieves some data. Based on this curso2 will also fetches some data. In cursor3 (using for some updation) I'm using the data retrieved by the above 2 cursor. My question is, while working with cursor3, periodically if I give commit, will all the three crsors will be closed or only cursor3 will be closed?

4 Answers  


What is meant by dclgen?

0 Answers  


What is ACQUIRE/RELEASE in BIND?

3 Answers   Cognizant,


how to resolve -805 . how to see dbrm and package not found

2 Answers   IBM,


Explain about mirror activator disk mirroring?

0 Answers  


what is contained in the DB2 node lock file? A) data base names B) data base users names C) license keys D) server names

5 Answers   Accenture,


Categories