Exam 1Z0-908 Topic 3 Question 86 Discussion

Actual exam question for Oracle's 1Z0-908 exam
Question #: 86
Topic #: 3
Examine this SQL statement:
mysql> GRANT r_read@localhost TO mark WITH ADMIN OPTION;
Which two are true? (Choose two.)

Suggested Answer: C,D Vote an answer

Explanation
https://dev.mysql.com/doc/refman/8.0/en/grant.html

by wordemoideen at Feb 25, 2024, 05:02 AM

Limited Time Offer

15%

Off

Get Premium 1Z0-908 Questions as Interactive Self Test Engine or PDF

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Nick name: Submit Cancel
wordemoideen
2024-02-25 20:02:26
mysqlpump requires at least the SELECT privilege for dumped tables, SHOW VIEW for dumped views, TRIGGER for dumped triggers, and LOCK TABLES if the --single-transaction option is not used.
upvoted 1 times
...
wordemoideen
2024-02-25 05:02:06
Revoke will Cancel update,insert roles.root user will have all roles.
upvoted 1 times
...
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.
0
0
0
10