Hi Guys, I have faced one interview question if I have requirement to add 5 new columns to existing table what are prerequisite do i need to take.
Answer Posted / manhem
Unload the data, Drop the table, recreate the table by adding 5 new columns.
or
Alter table will work, but it will add new columns at the last.
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the access modes of START statement?
Explain how you can characterize tables in cobol?
Write a cobol program making use of the redefine clause.
What is amode(24), amode(31), rmode(24) and rmode(any) (applicable to only mvsesa enterprise server) ?
What is redefines clause in COBOL?
How to print 10 to 1 if the input have only 10 digit number?
if we display var1 then what will b displayed in below condition. 77 var1 pic s9(2) value -10. 77 var1 pic s9(2) value -11. " " " -12. " " " -13. -14 ... ... -19.
What is the default value(s) for an initialize and what keyword allows for an override of the default?
What is the usage of comp fields in cobol?
INREC AND OUTREC? HOW TO SPLIT 5K RECORDS TO DIFFERENT FILES IN A FILE IN COBOL? RESTART IN COBOL-DB2? ISOLATION LEVELS?
What is a report item?
Explain how to differentiate call by context by comparing it to other calls?
Why would you use find and get rather than to obtain?
what is amode(24), amode(31), rmode(24) and rmode(any)?
Have you used the sort in your project?for this type of questions any working on real time project give the eg. with real time scenario.