DB2 INTERVIEW QUESTIONS


Home Forum Online Tutorials Interview Questions Mainframe Books IT News

Home > Discussion Forum > DB2 INTERVIEW QUESTIONS

DB2 INTERVIEW QUESTIONS

No of Questions : 114

Goto page Previous 1, 2, 3, 4, 5 ... 10, 11, 12 Next

DB2 INTERVIEW QUESTIONS

When do you use the IMAGECOPY?

Question : When do you use the IMAGECOPY?

View Answer(1)

What is IMAGECOPY ?

Question : What is IMAGECOPY ?

View Answer(1)

What is REORG? When is it used?

Question : REORG reorganizes data on physical storage to reclutser rows, positioning overflowed rows in their proper sequence, to reclaim space, to restore free space. It is used after heavy updates, inserts and delete activity and after segments of a segmented tablespace have become fragmented.

View Answer(0)

Give some example of statistics collected during RUNSTATS?

Question : Give some example of statistics collected during RUNSTATS?

View Answer(1)

When will you chose to run RUNSTATS?

Question : When will you chose to run RUNSTATS?

View Answer(1)

What is RUNSTATS?

Question : What is RUNSTATS?

View Answer(1)

How do you insert a record with a nullable column?

Question : How do you insert a record with a nullable column?