Section 5.9. Review Questions


5.9. Review Questions

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?

  1. db2set a

  2. db2set all

  3. db2set lr

  4. db2set -ltr

12:

Which two of the following are not database configuration parameters?

  1. SHEAPTHRES

  2. SHEAPTHRES_SHR

  3. BUFFPAGE

  4. MAX_QUERYDEGREE

  5. MAXLOCKS

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?

  1. Combine them into one database using different schemas

  2. Create all the databases in the same instance

  3. Put each database on a different drive/file system on the server

  4. 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?

  1. get dbm cfg

  2. get dbm cfg show detail

  3. get dbm cfg show all

  4. get complete dbm cfg

15:

Which of the following commands updates the DAS configuration?

  1. das update cfg

  2. db2 update dbm cfg for das

  3. db2admin update cfg

  4. db2 update admin cfg

16:

Which of the following commands changes the DAS configuration back to the default values?

  1. das reset cfg

  2. db2 reset dbm cfg for das

  3. db2admin reset cfg

  4. db2 reset admin cfg

17:

Which of the following commands stops the DB2 instance even if there are active connections to databases in the instance?

  1. db2 force applications all

  2. db2 stop all applications

  3. db2stop force

  4. db2stop applications all

18:

Which of the following commands/statements requires an attachment to a remote instance?

  1. db2 list applications

  2. db2 list db directory

  3. db2 select * from employee

  4. db2 create database mydb

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?

  1. db2 list database configuration

  2. db2 list db cfg

  3. db2 get dbm cfg

  4. db2 get db cfg

20:

Which two of the following commands do not set the value of the INTRA_PARALLEL parameter to YES?

  1. db2 update database manager configuration using INTRA_PARALLEL YES

  2. db2 update dbm cfg using INTRA_PARALLEL 1

  3. db2 update dbm cfg using INTRA_PARALLEL ON

  4. db2 update database configuration using INTRA_PARALLEL YES



Understanding DB2(R. Learning Visually with Examples)
Understanding DB2: Learning Visually with Examples (2nd Edition)
ISBN: 0131580183
EAN: 2147483647
Year: 2004
Pages: 313

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net