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

How and when does the db2 enforces the unique key?

0 Answers  


by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?

4 Answers   Mphasis,


What is pagespace?

1 Answers  


i have cobol+ db2 program but it contains n number of subprograms for this how many dbrm members i need to mention in bind process

2 Answers  


Can we declare DB2 HOST variable in COBOL COPY book?

2 Answers  






What is difference between isnull and coalesce?

0 Answers  


what is differnece between DROP TABLE & DELETE TABLE .

4 Answers   Cap Gemini,


Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?

0 Answers  


What is the maximum length of sqlca?

0 Answers  


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  


How do u achieve record level locking in DB2 versions when record level locking is not allowed?

2 Answers   IBM,


How to get the ddl of a table in db2?

0 Answers  


Categories