Learning Visually with Examples [Electronic resources]

Raul F. Chong, Clara Liu, Sylvia F. Qi, Dwaine R. Snow

نسخه متنی -صفحه : 312/ 43
نمايش فراداده

2.9. Review Questions

1:

How are DB2 commands classified?

2:

What is a quick way to obtain help information for a command?

3:

What is the difference between the Information Center tool and simply reviewing the DB2 manuals?

4:

What command is used to create a DB2 instance?

5:

How many table spaces are automatically created by the

CREATE DATABASE command?

6:

What command can be used to get a list of all instances on your server?

7:

What is the default instance that is created on Windows?

8:

Is the DAS required to be running to set up a remote connection between a DB2 client and a DB2 server?

9:

How can the DB2 environment be configured?

10:

How is the local database directory populated?

11:

Which of the following commands will start your DB2 instance?

  1. startdb

  2. db2 start

  3. db2start

  4. start db2

12:

Which of the following commands will list all of the registry variables that are set on your server?

  1. db2set a

  2. db2set all

  3. db2set lr

  4. db2set -ltr

13:

Say you are running DB2 on a Windows server with only one hard drive (C:). If the DB2 instance is dropped using the

db2idrop command, after recreating the DB2 instance, which of the following commands will list the databases you had prior to dropping the instance?

  1. list databases

  2. list db directory

  3. list db directory all

  4. list db directory on C:

14:

If the

list db directory on C: command returns the following:

Database alias                       = SAMPLE
Database name                        = SAMPLE
Database directory                   = SQL00001
Database release level               = a.00
Comment                              =
Directory entry type                 = Home
Catalog database partition number    = 0
Database partition number            = 0

which of the following commands must be run before you can access tables in the database?

  1. catalog db sample

  2. catalog db sample on local

  3. catalog db sample on SQL00001

  4. catalog db sample on C:

15:

If there are two DB2 instances on your Linux server,

inst1 and

inst2 , and if your default DB2 instance is

inst1 , which of the following commands allows you to connect to databases in the

inst2 instance?

  1. export inst2

  2. export instance=inst2

  3. export db2instance=inst2

  4. connect to inst2

16:

Which of the following DB2 registry variables optimizes interpartition communication if you have multiple partitions on a single server?

  1. DB2_OPTIMIZE_COMM

  2. DB2_FORCE_COMM

  3. DB2_USE_FCM_BP

  4. DB2_FORCE_FCM_BP

17:

Which of the following tools is used to run commands on all partitions in a multipartition DB2 database?

  1. db2_part

  2. db2_all

  3. db2_allpart

  4. db2

18:

Which of the following allows federated support in your server?

  1. db2 update db cfg for federation using FEDERATED ON

  2. db2 update dbm cfg using FEDERATED YES

  3. db2 update dbm cfg using NICKNAME YES

  4. db2 update dbm cfg using NICKNAME, WRAPPER, SERVER, USER MAPPING YES

19:

Which environment variable needs to be updated to change the active logical database partition?

  1. DB2INSTANCE

  2. DB2PARTITION

  3. DB2NODE

  4. DB2PARTITIONNUMBER

20:

Which of the following statements can be used to determine the value of the current active database partition?

  1. values (current dbpartitionnum)

  2. values (current db2node)

  3. values (current db2partition)

  4. values (current partitionnum)