DB2 11.1 Fundamentals for LUW: C2090-616

Which DB2 product required to allow connections from DB2 LUW to DB2 on z/OS?

A. DB2 Connect

B. DB2 Runtime Client

C. DB2 Data Server Client

D. DB2 Enterprise Server Edition

The following statements are executed:

GRANT CREATETAB, DATAACCESS, ON DATABASE TO ROLE role A;

GRANT CREATETAB, BINDADD ON DATABASE TO ROLE role B;

GRANT ROLE role A to USER db2inst3;

GRANT ROLE role B to USER db2inst3;

Which of the following is TRUE if this statement is executed later?

REVOKE ROLE roleB FROM USER db2inst3;

A. This statement will succeed and DB2 INST3 will still be able to create in the database.

B. This statement will succeed and DB2 INST3 only retains DATAACCESS privileges on the database.

C. This statement will fail as CREATETAB is granted to two different roles and must be revoked at the same time.

D. This statement will succeed with a warning since CREATETAB cannot be totally revoked. DB2INST3 will retain both roles.

Which of the following is TRUE regarding user switching in a trusted context?

A. You cannot switch user id in a trusted context.

B. You can issue a switch-user request within a transaction.

C. The new user must have the connect-privilege on the database for it to succeed.

D. No password is ever required for the new user as an authentication is established in the trusted connection.