What is a page?

DB2 ( IBM Database 2 ) Interview Questions

(Continued from previous question...)

What is a page?

This is the unit of storage within a table space or index space that is accessed by DB2.

(Continued on next question...)

Other Interview Questions

• What does the RUNSTATS Utility do?
• What is meant by index cardinality?
• What techniques are used to retrieve data from more than one table in a single SQL statement?
• What is the difference between join and union ?
• What techniques are used to retrieve data from more than one table in a single SQL statement?
• What are the various locks available?
• How can you quickly find out the number of rows updated after an update statement?
• Which DB2 command is used to retireve environmental information?
• What is lock escalation?
• What is the purpose of the WHENEVER statement?
• More...