How does DB2 determine what lock-size to use?

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

How does DB2 determine what lock-size to use?

1. Based on the lock-size given while creating the tablespace
2. Programmer can direct the DB2 what lock-size to use
3. If lock-size ANY is specified, DB2 usually chooses a lock-size of PAGE

(Continued on next question...)

Other Job Interview Questions

• What is index cardinality? –
• What is the COBOL picture clause for a DB2 column defined as DECIMAL(11,2)?
• What is the picture clause of the null indicator variable? –
• What is a cursor? why should it be used? –
• Can I use LOCK TABLE on a view?
• What techniques are used to retrieve data from more than one table in a single SQL statement?
• When would you prefer to use VARCHAR?
• Explain difference between sys.cat and sys.ibm?
• How do you simulate the EXPLAIN of an embedded SQL statement in SPUFI/QMF? Give an example with a host variable in WHERE clause.)
• What is filter factor?
• More...