Exam 1z0-908 topic 1 question 20 discussion

Actual exam question from Oracle's 1z0-908

Question #: 20
Topic #: 1

[All 1z0-908 Questions]

Examine this SQL statement:
mysql> GRANT r_read@localhost TO mark WITH ADMIN OPTION;
Which two are true? (Choose two.)

A. Mark can grant the privileges assigned to the r_read@localhost role to another user.
B. ADMIN OPTION causes the role to be activated by default.
C. Mark can grant the r_read@localhost role to another user.
D. Mark can revoke the r_read@localhost role from another role.
E. ADMIN OPTION allows Mark to drop the role.
F. Mark must connect from localhost to activate the r_read@localhost role.

Show Suggested Answer

Suggested Answer: CD 🗳️

by FelipeK at March 28, 2023, 10:50 a.m.

Comments

Submit Cancel

TheBCat

7 months, 1 week ago

Selected Answer: CD

If you were granted a role with a GRANT statement that includes the WITH ADMIN OPTION clause, you become able to grant that role to other users or roles, or revoke it from other users or roles, as long as the role is active at such time as you subsequently grant or revoke it. This includes the ability to use WITH ADMIN OPTION itself

upvoted 1 times

...

abpg

7 months, 2 weeks ago

Selected Answer: AC

A. Mark can grant the privileges assigned to the r_read@localhost role to another user: This is correct because WITH ADMIN OPTION allows mark to manage the privileges associated with the role, including granting those privileges to other users. C. Mark can grant the r_read@localhost role to another user: This is also correct, as WITH ADMIN OPTION allows mark to grant the role itself to other users.

upvoted 1 times

...