What is a data page?

DB2 ( IBM Database 2 ) Interview Questions

(Continued from previous question...)

What is a data page?

A data page is a unit of retrievable data, either 4K or 32K ( depending on how the table is defined ), containing user or catalog information.

(Continued on next question...)

Other Interview Questions

• Which command is issued to establish the Boot Strap Data Set after an I/O failure?
• What is normalization and what are the five normal forms?
• Can you access the DB2 Directory table using SQL?
• Under what circumstances will DB2 allow an SQL satement ...
• What are leaf pages?
• What is a buffer pool ?
• Usually, which is more important for DB2 system performance
• Compare a subselect to a join?
• When is the access path determined for dynamic SQL?
• What happens to the PLAN if index used by it is dropped?
• More...