Understanding DB2: Learning Visually with Examples (2nd Edition)

10.10. Review Questions

1:

Where does DB2 store information about the users who can access DB2?

2:

Besides performing user ID and password authentication at the DB2 server or DB2 client, what other authentication mechanisms does DB2 support?

3:

When does a user need the BINDADD privilege on a database?

4:

If bob is connected to a database and wants to create a table foo in the ts1 table space, what privileges must he have to run the following statement?

CREATE TABLE mary.foo (c1 INT, c2 INT) IN ts1

5:

A user ID bob that is a member of group dba is defined on the DB2 server. Why would the following fail to give SYSCTRL authority to user bob?

update dbm cfg using sysctrl bob

6:

In a Windows environment where a DB2 server is defined inside a domain called domprod, user ID db2admin is only defined in the domain controller as a member of the global group glbgrp. If you want to log on to the DB2 server as the domain user domprod\db2admin and perform tasks such as creating a new database, what are the three key steps you have to take?

7:

You want to authenticate users at the clients. What are the three types of clients that the parameter TRUST_ALLCLNTS evaluates?

8:

You have just created a database. Other than the members of the SYSADM group, you want to allow only bob to create new tables in the database. What DCL command do you have to issue?

9:

Mary wrote an embedded SQL program with static SQL statements. A package is created and bound to the database. What privilege does bob need to use the package?

10:

Given the following Database Manager Configuration parameters on your DB2 instance running on the Linux Server DBL1:

Database manager authentication (AUTHENTICATION) = CLIENT Trust all clients (TRUST_ALLCLNTS) = NO Trusted client authentication (TRUST_CLNTAUTH) = CLIENT

If you are connecting to the database from a Windows ME client, where will authentication take place?

11:

If you are connecting to a DB2 database on a UNIX server named DBX1 from a Linux client named DBL1, where will the user ID be authenticated by default?

  1. DBL1

  2. DBX1

12:

If you have configured DB2 with the authentication set to SERVER_ENCRYPT, which of the following describes what is encrypted?

  1. Data

  2. Data and user IDs

  3. User IDs and passwords

  4. Data, user IDs, and passwords

13:

Given the following Database Manager Configuration parameters on your DB2 instance running on the Linux Server DBL1:

Database manager authentication (AUTHENTICATION) = CLIENT Trust all clients (TRUST_ALLCLNTS) = YES Trusted client authentication (TRUST_CLNTAUTH) = CLIENT

If you are connecting to the database from a Windows ME client, where will authentication take place?

  1. The client

  2. The server

14:

Which two of the following DB2 authorities can select data from tables?

  1. SYSADM

  2. SYSCTRL

  3. SYSMAINT

  4. DBADM

  5. SYSMON

15:

Which of the following can be encrypted with DB2?

  1. User IDs

  2. Passwords

  3. All data

  4. User IDs, passwords, and data

16:

Which of the following groups can create and drop event monitors?

  1. SYSADM

  2. SYSMON

  3. SYSCTRL

  4. SYSMAINT

17:

Which of the following authorities cannot take a DB2 trace?

  1. SYSADM

  2. SYSMON

  3. SYSCTRL

  4. SYSMAINT

18:

Given the following:

  • User1 grants CREATEIN privilege on the schema to Fred with grant option

  • Joe grants CREATEIN privilege on the schema foo to Barney with grant option

  • User1 revokes CREATEIN privilege on the schema foo from Fred.

  • Barney grants CREATEIN privilege on the schema foo to Wilma.

  • Wilma grants CREATEIN privilege on the schema foo to Betty.

Which of the following still have CREATEIN privilege on the schema foo?

  1. Barney

  2. Barney and Wilma

  3. Barney, Wilma, and Betty

  4. No one

19:

Given the table space tsp1 that is created with default options, which of the following sets of commands will ensure only the group grp1 can use the table space?

  1. GRANT USE OF TABLESPACE tsp1 TO grp1

  2. GRANT USER OF TABLESPACE tsp1 TO grp1 WITH GRANT OPTION

  3. REVOKE USE OF TABLESPACE FROM ALL

  4. GRANT USE OF TABLESPACE tsp1 TO GRP1

  5. REVOKE USE OF TABLESPACE FROM PUBLIC

  6. GRANT USE OF TABLESPACE tsp1 TO GRP1

20:

If a DBA wants to find out whether user bob has CREATETAB privileges, which of the following system catalog tables should the DBA query?

  1. SYSCAT.TABAUTH

  2. SYSCAT.TABLES

  3. SYSCAT.DBAUTH

  4. SYSCAT.SCHEMAAUTH

Related

Категории