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.



Hi Guys, I have faced one interview question if I have requirement to add 5 new columns to existing..

Answer / 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

More COBOL Interview Questions

How to code fscode 10 in cobol program? Where yoy code in your pgm?give ans for the question.

2 Answers   IBM,


What do you do to resolve SOC-7 error?

2 Answers   Sun Life, Wipro,


Write the code implementing the perform … varying.

0 Answers  


How to pass return codes from cobol to jcl?

5 Answers  


What is perform what is varying?

0 Answers  


what will happen if pass values more than 100 using PARM parameter?

1 Answers  


Have you code any new programs in COBOL ? What is the functionality of the programs?

2 Answers   Patni, Xansa,


Following questions were asked in Capegemini on 8th sep,2012 mainframe test 1.)Condition code for dul recors in VSAM- 2.) Is NULL or =NULL in Select statement 3.)max size of CI 4.)What happens after CI is full 5.)Ques on COND parameter 6.)which among following can not be rolled back a)delete table b.)droptable c)Update d.)insert 7.)groupby and orderby sql querries 8.)Max extents in VSAM file 9.)quesn on DPRTY=(1,10) 10.)range of condition codes in COBOL 11.)occurs clase can not be used at which level? 12.)delimiter in jcl 13.)sort card for file in PGM=SORT 14.)PIC(6) value 120056 possible? 15)question on BLKSIZE Is (20,20) and (20,10) possible? 16.)number of bytes in RDF 17.)Can we use index in WS-section or LK-section 18.)Verify command in IDCAMS used for? 19.)question on Alternate Index 20.)Return code of file attribute mismatch 21.)In which format COBOL variables stored? 22.)what is Alternate of HANDLE? 23.)can SUM,AVG,MIN,ROUND used in numeric and char variable data types? 24.)What is the datatype of FILE STATUS codes in WS-section?

2 Answers   Cap Gemini,


What is the significance of 'above the line' and 'below the line'?

2 Answers   Nokia,


What is the difference between NEXT SENTENCE and CONTINUE?

2 Answers   Mphasis,


What is 66 level number and where it is used in real time by software developers?

2 Answers   ITC Indian Tobacco Company, TCS,


how many divisions are there in cobol

3 Answers   ADP,


Categories