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

  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
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
13.59.200.206