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
1.give the details about WHEN OTHER. 2. how many form are available in evaluate.
What are the different rules of SORT operation?
What is inspect in cobol ?
IF I mention stop run in CICS what happens?
What is the difference between structured cobol programming and object alternativelyiented cobol programming?
how to access the file from prodution from changeman tool and to submit a file to production
How to use the same COBOL program in Batch and CICS on lines? explain with an example
How many bytes S(8) comp field occupy and its maximum value?
How to remove the spaces at the end of each record in the output file of variable length, via cobol program?
Is it possible that the redefines clause has different picture clauses compared to the one it redefined?
Write a program to enter and display the names of students in a class using the occurs clause.
i want a program using by if, evaluate , string, unstring, perform, occurs?
what happens if parmparameter passes zero bytes to the program
In COBOL, what is the different between index and subscript?
Difference between array and sub-script ?