Learning Visually with Examples [Electronic resources] نسخه متنی

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

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

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

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 

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 

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?

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

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?

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?

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?

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

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

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

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

1. SYSADM

2. SYSCTRL

3. SYSMAINT

4. DBADM

5. SYSMON

Which of the following can be encrypted with DB2?

1. User IDs

2. Passwords

3. All data

4. User IDs, passwords, and data

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

1. SYSADM

2. SYSMON

3. SYSCTRL

4. SYSMAINT

Which of the following authorities cannot take a DB2 trace?

1. SYSADM

2. SYSMON

3. SYSCTRL

4. SYSMAINT

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

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

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