Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

What the difference is between continue and next sentence?

1221


Program A (Normal COBBAT) calling a B Program (DB2COBOL, COBBATDB which is using a VSAM file. its a dynamic call. How we will handle VSAM file decleration in our from JCL from where we are running A PGM. And should we have PLAN for A pGM also. if possible can some one post a sample JCL. Thanks for help in advance.

5796


If you are current on the owner of a set, what is the difference between an obtain next and obtain first? Actually in which topic will we use dis???Plz explain it clearly

3214


How do define dynamic array in cobol.

1185


write a cobol logic. i have file that has 10 records .1 record go to first output file and second record goes to 2 output and etc

1301


)If there are 10 steps in GDG, if I want to refer the step2 after step5 . what should I do?

2066


I have to write to a outfile where the number of records in that file should be the header of that file using IMS.. can anyone help me in this issue

2607


What is the difference between comp and comp-3 usage?

1260


What is redefines clause in COBOL?

1351


How can we find that module can be called – whether DYNAMICALLY or STATICALLY?

1268


Name the sections present in data division.

1315


Is it possible that the redefines clause has different picture clauses compared to the one it redefined?

1211


how do you reference the printer file formats from cobol programs

1283


What are 77 levels used for?

1152


What is an in line perform? When would you use it? Anything else you wish to say about it.

1143