IBM Exam C2090-616 Topic 7 Question 26 Discussion

Actual exam question for IBM's C2090-616 exam

Question #: 26
Topic #: 7

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;

AThis statement will succeed and DB2 INST3 will still be able to create in the database

BThis statement will succeed and DB2 INST3 only retains DATAACCESS privileges on the database

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

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

Show Suggested Answer

Suggested Answer: D

by Tasia at May 07, 2022, 06:23 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!