8.8. Review Questions

1:What is the largest number of partitions supported by DB2?
2:What is the name of the buffer pool created automatically by DB2 in every database?
3:For the table created as: 
								CREATE TABLE mytable (col1   VARCHAR(100),
								Col2   int,
								Col3   VARCHAR(9000)
								)

what is the minimum page size required?

4:What type of object is stored in the DB2 file SQL00018.DAT?
5:What command can be used to determine the amount of free space in a table space?
6:Which type of table space is preallocated when it is created?
7:Which type of table space can grow and shrink as tables grow and shrink within it?
8:When can a user-defined table space not be dropped?
9:What is the main reason for creating a block-based area in your buffer pool?
10:Which command can be ...

Get Understanding DB2®: Learning Visually with Examples now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial