26.
What is normalization and what are the five normal forms?
Normalization is a design procedure for representing data in tabular format The five normal forms are progressive rules to represent the data with minimal redundancy.
27.
What is lock escalation?
Promoting a PAGE lock-size to table or tablespace lock-size when a transaction has acquired more locks than specified in NUMLKTS. Locks should be taken on objects in single tablespace for escalation to occur.
28.
What are the various locks available?
SHARE, EXCLUSIVE, UPDATE
29.
Can I use LOCK TABLE on a view?
No. To lock a view, take lock on the underlying tables.
30.
What is ALTER?
SQL command used to change the definition of DB2 objects.
|
|
||||||||||||||||||||||||||||
