Learning Visually with Examples [Electronic resources]

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