can I alter a table (e.g. adding a column) when other user is selecting some c

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?

Question Posted / guest

can I alter a table (e.g. adding a column) when other user is selecting some columns or updating s..

No, Because it requires an EX lock on the DBD to make
alters to the table description.

Is This Answer Correct ?

5 Yes

0 No

More DB2 Interview Questions

Name the various locking levels available?

If I have a view which is a join of two or more tables, can this view be updateable?

How can you compare table column after update and before update?

When do you specify the isolation level? How?

How to rename a table in DB2 ?

What is the difference between Primary key and unique index?

What are the contents of dclgen?

What is release/acquire in bind?

what types of copies can be made with the COPY Utility ?

How will you return the number of records in table?

What is dclgen (declaration generator)?

Define db2 and its databases?

For more DB2 Interview Questions Click Here