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

What are the abend codes occour in ur latest PROJECT in DB2

Do we need cursor for Count(*)?

How will fetch last 5 rows from table in db2

Is it possible to create an Instance in DB2 using DB2 Control Center ?

What is the use of reorg in db2?

What is a composite index and how does it differ from a multiple index?

What does the RUNSTATS Utility do?

what are extents?

what is the Foreign key? explain?

Can a primary key have null values? If we try to insert a null value in a primary key column, will it work or give an error code?

How to select the duplicate rows from a table?

Give the name of some fields form sqlca.

For more DB2 Interview Questions Click Here