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 used to determine if a rebalance is occurring due to the addition or removal of a container in the table space? |
11: | Which of the following page sizes is not supported by DB2?
|
12: | If a database has 12 table spaces all using an 8K page size, what is the minimum number of buffer pools that must exist in the database?
|
13: | Given the following db2nodes.cfg file:
0 mysrv1 0 1 mysrv1 1 2 mysrv2 0 3 mysrv2 1 what is the largest table that can exist in a database created in this instance?
|
14: | Given the following db2nodes.cfg file for the instance inst1:
0 mysrv1 0 1 mysrv1 1 2 mysrv2 0 3 mysrv2 1 and the command create database foo on /data, what directories will be created under the /data directory?
|
15: | Given the following db2nodes.cfg file for the instance inst1:
0 mysrv1 0 1 mysrv1 1 2 mysrv2 0 3 mysrv2 1 and the command create database foo on /data, what directories will be created under the /data/inst1 directory on server mysrv2?
|
16: | Given a newly created nonpartitioned instance on Windows named DB2 and the command create database foo on C:, how many directories will be created under the subdirectory C:DB2NODE0000SQL00001?
|
17: | Given the following sequence of events:
what subdirectory will the database my_sales be located in?
|
18: | Given the following db2nodes.cfg file for the instance inst1:
0 mysrv1 0 1 mysrv1 1 2 mysrv2 0 3 mysrv2 1 and the following sequence of commands: telnet myserv2 create database foo on /data which of the following is the catalog partition for the database foo?
|
19: | To create the table space TS1 successfully in the database sample, place the following steps in the correct order:
|
20: | Given a database with six partitions, which of the following statements will create a buffer pool with a size of 100MB on partitions 1, 2, 3, 4, and 5, and a size of 150MB on partition 0?
|