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

How many databases can be created inside an instance in db2 ?

How do you insert a record with a nullable column?

What is a plan and package in db2?

What is the difference between db2 and oracle?

how to identify the pseudo conversation by seeing the program

What is the difference between IN subselects and EXISTS subselect?

What are foreign keys?

Define predicate?

Mention the length of physical storage of the given data types of db2 – date, timestamp, time

what is the maximum number of tables that can be joined ?

What is concurrency in db2?

Explain transactions, commits and rollbacks in DB2.

For more DB2 Interview Questions Click Here