Section 8.8. Review Questions

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 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?

1. 2K

2. 4K

3. 8K

4. 16K

5. 32K

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?

1. 1

2. 2

3. 8

4. 12

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?

1. 64GB

2. 256GB

3. 1TB

4. 2TB

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?

1. NODE0002 and NODE0003

2. NODE0000 and NODE0001

3. DB2

4. inst1

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?

1. NODE0002 and NODE0003

2. NODE0000 and NODE0001

3. NODE0002

4. NODE0000, NODE0001, NODE0002, and NODE0003

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

1. 1

2. 2

3. 3

4. 4

5. 5

17:

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

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?

1. Partition 0

2. Partition 1

3. Partition 2

4. Partition 3

19:

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

1.	CREATE TABLESPACE ts1 PAGESIZE 16K BUFFERPOOL bp1
2.	CONNECT TO sample
3.	CREATE BUFFERPOOL bp1 SIZE 100000 PAGESIZE 16K

1. 1, 2, 3

2. 3, 2, 1

3. 2, 1, 3

4. 2, 3, 1

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?

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