Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
exam questions

Exam C2090-616 All Questions

View all questions & answers for the C2090-616 exam

Exam C2090-616 topic 1 question 14 discussion

Actual exam question from IBM's C2090-616
Question #: 14
Topic #: 1
[All C2090-616 Questions]

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
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
JamesBond
3 years, 4 months ago
A. This statement will succeed and DB2 INST3 will still be able to create in the database ONE COMMAND cannot revoke both roles privilege's, as the are set of roles.
upvoted 1 times
...
Kalliopi
4 years, 2 months ago
I agree, the most suitable answer is A.
upvoted 2 times
...
db2tester
5 years, 1 month ago
The good answer is A. This statement will succeed and DB2 INST3 will still be able to create in the database With DB2, you do not have warning when you run revoker query.
upvoted 3 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...