| 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? startdb db2 start db2start start db2
|
| 12: | Which of the following commands will list all of the registry variables that are set on your server? db2set a db2set all db2set lr 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? list databases list db directory list db directory all 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? catalog db sample catalog db sample on local catalog db sample on SQL00001 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? export inst2 export instance=inst2 export db2instance=inst2 connect to inst2
|
| 16: | Which of the following DB2 registry variables optimizes interpartition communication if you have multiple partitions on a single server? DB2_OPTIMIZE_COMM DB2_FORCE_COMM DB2_USE_FCM_BP DB2_FORCE_FCM_BP
|
| 17: | Which of the following tools is used to run commands on all partitions in a multipartition DB2 database? db2_part db2_all db2_allpart db2
|
| 18: | Which of the following allows federated support in your server? db2 update db cfg for federation using FEDERATED ON db2 update dbm cfg using FEDERATED YES db2 update dbm cfg using NICKNAME YES 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? DB2INSTANCE DB2PARTITION DB2NODE DB2PARTITIONNUMBER
|
| 20: | Which of the following statements can be used to determine the value of the current active database partition? values (current dbpartitionnum) values (current db2node) values (current db2partition) values (current partitionnum)
|
