Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More DB2 Interview Questions

i have table agdet i want first 5 maximum commission which query will you write for this thanks in advance

3 Answers  


How to rename a table in DB2 ?

0 Answers   MCN Solutions,


Explain about open switch business continuity software?

0 Answers  


In my table having 100 Rec. How can I delete the 7th row?? (we don't know what is data inside the table)

9 Answers   IBM,


how to get duplicate records from tables?write qurey for this?

4 Answers   ANZ,






What do you mean by cursor?

0 Answers  


how can u retrieve the data from null values using applicaion program.

3 Answers   TCS,


What is a NULL value? What are the pros and cons of using NULLS?

2 Answers  


What are PACKAGES ?

3 Answers  


before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?

0 Answers   IBM,


What is the difference between static and dynamic SQL?

1 Answers  


Explain correlated sub-queries.

0 Answers  


Categories