What is the difference between drop table and delete table?


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

Post New Answer

More DB2 Interview Questions

Normalization in DB2 – first normal form, second normal form

4 Answers   Virtusa,


How can i install db2 9.x on AIX based system..? plz reply the detailed steps involved....?

0 Answers   IBM, TCS,


What is reorg and runstats in db2?

0 Answers  


What is dpf in db2?

0 Answers  


How do you simulate the explain of an embedded sql statement in spufi/qmf?

0 Answers  






What is dbrm?

0 Answers  


What is cursor stability?

1 Answers  


How to resolve SQL Code -310. The db table feild is declared as Decimal(7,2).

2 Answers   IBM, Infosys,


Is it Possible to declare or create a cursor for UPDATE of table? If yes tell me how? If no Tell me why?

1 Answers   IBM, scintel,


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 Skeleton cursor table (SKCT)?

2 Answers  


What is database reorganization?

0 Answers  


Categories