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 domproddb2admin 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?
|
12: | If you have configured DB2 with the authentication set to SERVER_ENCRYPT, which of the following describes what is encrypted?
|
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?
|
14: | Which two of the following DB2 authorities can select data from tables?
|
15: | Which of the following can be encrypted with DB2?
|
16: | Which of the following groups can create and drop event monitors?
|
17: | Which of the following authorities cannot take a DB2 trace?
|
18: | Given the following:
Which of the following still have CREATEIN privilege on the schema foo?
|
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?
|
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?
|