Understanding DB2: Learning Visually with Examples (2nd Edition)

What is the largest number of partitions supported by DB2?

What is the name of the buffer pool created automatically by DB2 in every database?

For the table created as:

CREATE TABLE mytable (col1 VARCHAR(100), Col2 int, Col3 VARCHAR(9000) )

what is the minimum page size required?

What type of object is stored in the DB2 file SQL00018.DAT?

What command can be used to determine the amount of free space in a table space?

Which type of table space is preallocated when it is created?

Which type of table space can grow and shrink as tables grow and shrink within it?

When can a user-defined table space not be dropped?

What is the main reason for creating a block-based area in your buffer pool?

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?

Which of the following page sizes is not supported by DB2?

1. 2K

2. 4K

3. 8K

4. 16K

5. 32K

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?

1. 1

2. 2

3. 8

4. 12

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?

1. 64GB

2. 256GB

3. 1TB

4. 2TB

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?

1. NODE0002 and NODE0003

2. NODE0000 and NODE0001

3. DB2

4. inst1

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?

1. NODE0002 and NODE0003

2. NODE0000 and NODE0001

3. NODE0002

4. NODE0000, NODE0001, NODE0002, and NODE0003

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:\DB2\NODE0000\SQL00001?

1. 1

2. 2

3. 3

4. 4

5. 5

Given the following sequence of events:

1. Create database sample on C:.

2. Create database sales on C:.

3. Create database test on C:.

4. drop db sales

5. create db my_sales

what subdirectory will the database my_sales be located in?

1. SQL00001

2. SQL00002

3. SQL00003

4. SQL00004

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?

1. Partition 0

2. Partition 1

3. Partition 2

4. Partition 3

To create the table space TS1 successfully in the database sample, place the following steps in the correct order:

1. 1, 2, 3

2. 3, 2, 1

3. 2, 1, 3

4. 2, 3, 1

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?

1. CREATE BUFFERPOOL BP1 SIZE 100MB on all DBPARTITIONNUMS except DBPARTITIONNUM 0 size 150MB

2. CREATE BUFFERPOOL BP1 SIZE 100MB on DBPARTITIONNUMS 1,2,3,4,5 150MB on DBPARTITIONNUM 0

3. CREATE BUFFERPOOL BP1 SIZE 150MB except on DBPARTITIONNUMS 1,2,3,4,5 size 100MB

4. CREATE BUFFERPOOL BP1 SIZE 100MB on DBPARTITIONNUMS 1,2,3,4,5 SIZE 150MB on DBPARTITIONNUM 0