26.
Define normalization ?
Normalization is a design procedure for representing data in tabular format.
27.
Define lock escalation?
When the number of row, page locks held per tablespace exceeds the LOCKMAX value or NUMLKUS or NUMLKTS, the lock is escalated to a tablespace lock.
28.
What are the various locks available?
The various locks are SHARE, EXCLUSIVE, UPDATE.
29.
Is it possible to use LOCK TABLE on a view?
No. To lock a view,we should take lock on the underlying tables.
30.
Define ALTER?
ALTER is a command used to change the definition of DB2 objects.