1: | Which environment variable determines the current active instance on your database server? |
2: | How can you set up your DB2 environment in Linux or UNIX? |
3: | Which command can you use to remove the DB2COMM registry variable from the DB2 Global-Level Profile Registry? |
4: | Which command can you use to list all the instances in your server? |
5: | What authority is required to create a DB2 instance on Linux or UNIX? |
6: | What authority is required to create a DB2 instance on Windows? |
7: | What command can be used to remove an unneeded instance from your server? |
8: | Does the db2start command need to be executed once per each database partition? |
9: | What can you do to gain exclusive access to an instance? |
10: | What is the difference between an attachment and a connection? |
11: | Which of the following commands will list all of the available registry variables in DB2?
|
12: | Which two of the following are not database configuration parameters?
|
13: | You have three databases: one for development, one for test, and one for production. To ensure that an error in an application in the development database will not affect the other databases, how would you configure these databases?
Combine them into one database using different schemas Create all the databases in the same instance Put each database on a different drive/file system on the server Create each database in a different instance
|
14: | Which of the following commands will show the current and delayed values for the Database Manager Configuration parameters?
|
15: | Which of the following commands updates the DAS configuration?
db2 update dbm cfg for das
|
16: | Which of the following commands changes the DAS configuration back to the default values?
db2 reset dbm cfg for das
|
17: | Which of the following commands stops the DB2 instance even if there are active connections to databases in the instance?
db2 force applications all db2 stop all applications
|
18: | Which of the following commands/statements requires an attachment to a remote instance?
db2 select * from employee
|
19: | Which of the following commands can be used to review the contents of the Database Configuration file for the database to which you are currently connected?
db2 list database configuration
|
20: | Which two of the following commands do not set the value of the INTRA_PARALLEL parameter to YES?
db2 update database manager configuration using INTRA_PARALLEL YES db2 update dbm cfg using INTRA_PARALLEL 1 db2 update dbm cfg using INTRA_PARALLEL ON db2 update database configuration using INTRA_PARALLEL YES
|