DBA > Job Interview Questions > DB2 ( IBM Database 2 ) Interview Questions

an I alter a table when other user is selecting

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

an I alter a table when other user is selecting some columns ...

Q: can I alter a table (e.g. adding a column ) when other user is selecting some columns or updating some columns from the same table ?

An:
Yes possible. Until the updation or selection is committed DB2 table will not be restructured, New column definition will be there but it will not be included until all the tasks on the table are committed.

(Continued on next question...)

Other Job Interview Questions