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

Can we able to find all the Table names under a Particular Plan?

1 Answers   CTS,


How does DB2 determine what lock-size to use?

2 Answers  


How to check sequence on a table in db2?

0 Answers  


How does one bind 2 versions of a CICS transaction with the same module name in two different CICS regions that share the same DB2 subsystem?

2 Answers  


What is the difference between using bind () and rebind () methods of naming class?

0 Answers  


if there is a table with huge number of records and if i want to extract only first 3 records from the table, what query i have to provide to retreive first 3 records

4 Answers   UST,


What is universal database?

0 Answers  


How Plan is created while executing the query using SPUFI?

3 Answers  


What kind of database is db2?

0 Answers  


Under what circumstances will DB2 allow an SQL statement to update more than one primary key value at a time?

1 Answers  


Can we use group-by clause in sub-query? If 'yes' means,Will it be executed successfully or else If 'no' means why should we not using that method? Give me your suggestion please....

1 Answers  


which authority can be granted to group of users using the GRANT stmt? A) SYSCTRL B) SYSADM C) DBCTRL D) DB ADM

3 Answers   Accenture,


Categories