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

What is the usage of comp fields in cobol?

0 Answers  


Why is it necessary that file needs to be opened in I-O mode for REWRITE?

0 Answers  


Describe the cobol database components?

0 Answers  


how to remove leading spaces and zeroes in a cobol variable.is there any easy way to do it

2 Answers  


How many maximum number of procedures can we write in one COBOL program?

6 Answers  






BY seeing a program how can we say that it is static call or dynamic call

5 Answers   CGI,


If there are two files one with 100 records and other with 101 records. we have to find out the one record that is the odd man out . What are the steps to do it

7 Answers   BirlaSoft,


why 02 level number can't be use as a separate level number like 01 or 77 ?

3 Answers  


hi friends,can any one post the ibm mainframe inteqview questions for 1year exp candidate,for itc infotech interview?. have any body attended for this in the past?...

1 Answers   ITC Infotech,


Give some examples of command terminators?

0 Answers  


consider the following two statements MOVE 10 TO N PERFORM PARA-X N TIMES STOP RUN PARA-X MOVE 5 TO N how many times PARA-X willbe exicuted? a.10 b.5 c.infinate d.execution error

6 Answers   ABCL, TCS,


how to convert vsam table into DB2 table?

1 Answers   IBM, Wipro,


Categories