exam questions

Exam 1z0-908 All Questions

View all questions & answers for the 1z0-908 exam

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

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
TheBCat
2 weeks, 5 days 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
4 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
...
nkanike1
1 year, 2 months ago
C and D
upvoted 1 times
...
xexeu
1 year, 6 months ago
C and D
upvoted 1 times
...
fthusa
1 year, 8 months ago
What about C , answer C also correct
upvoted 1 times
...
FelipeK
1 year, 8 months ago
Selected Answer: CD
https://dev.mysql.com/doc/refman/8.0/en/grant.html
upvoted 2 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 ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago