Can I use LOCK TABLE on a view?

Question Posted / guest

1 Answers
6950 Views
I also Faced
E-Mail Answers

Can I use LOCK TABLE on a view?..

Answer / s

You can use LOCK TABLE on any table. View is not a
physical object.

Is This Answer Correct ?

4 Yes

2 No

Post New Answer

More DB2 Interview Questions

What is nvl in db2?

0 Answers

List out the three types of page locks that can be held.

0 Answers

What are foreign keys?

1 Answers

For unmatched rows returned from an outer join, the column values in the other table are set to null e.g If A OUTER JOIN B returns some unmatched rows from A, the corresponding column values in B will be set to null. What can be done so that a null value is not displayed for these columns?

3 Answers

What is ACQUIRE/RELEASE in BIND?

3 Answers Cognizant,

What is index cardinality?

3 Answers

How to define the a field which accepts value till 99999.99 in db2

3 Answers

How can deadlocks be resolved?

0 Answers

What statistic will tell the DBA how must space can be reclaimed from dropped table spaces on the next reorg run?

1 Answers

Lot of updates have been done on a table due to which indexes have gone haywire. What do you do?