manhem


{ City }
< Country > india
* Profession *
User No # 123680
Total Questions Posted # 0
Total Answers Posted # 1

Total Answers Posted for My Questions # 0
Total Views for My Questions # 0

Users Marked my Answers as Correct # 0
Users Marked my Answers as Wrong # 0
Questions / { manhem }
Questions Answers Category Views Company eMail




Answers / { manhem }

Question { 2123 }

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

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