Unload the data, Drop the table, recreate the table by adding 5 new columns

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.

Question Posted / manhem

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

Please Help Members By Posting Answers For Below Questions

Name the divisions, which are available in a cobol program?

1169

What type of SDLC u followed? Why?

1957

What is report-item in COBOL?

1094

What is amode(31)

1109

1.give the details about WHEN OTHER. 2. how many form are available in evaluate.

2060

How do you differentiate between cobol and cobol-ii?

1129

What is comp-1 and comp-2?

1186

Can you please let me know the centre name of INS certification in Kolkata.

2181

what is search and searchall?what is the diffrence between them?give an best example?

6666

How do define dynamic array in cobol. how do you define single dimensional array and multidimensional array in your cobol?

1186

What are various search techniques in cobol? Explain.

1026

There are 5 fields and 1000 records in a file. Unload it into an array. Write the syntax for declaration and how will you unload it.

1383

how can i see junk values in dclgen or in hostvariable of comp ?

2933

What is link edit in cobol?

1152

Write a program to enter and display the names of students in a class using the occurs clause.

1154