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
Name the divisions, which are available in a cobol program?
What type of SDLC u followed? Why?
What is report-item in COBOL?
What is amode(31)
1.give the details about WHEN OTHER. 2. how many form are available in evaluate.
How do you differentiate between cobol and cobol-ii?
What is comp-1 and comp-2?
Can you please let me know the centre name of INS certification in Kolkata.
what is search and searchall?what is the diffrence between them?give an best example?
How do define dynamic array in cobol. how do you define single dimensional array and multidimensional array in your cobol?
What are various search techniques in cobol? Explain.
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.
how can i see junk values in dclgen or in hostvariable of comp ?
What is link edit in cobol?
Write a program to enter and display the names of students in a class using the occurs clause.