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

Oracle 1z0-908 Question Answer

Examine this SQL statement:

mysql> GRANT r_read@localhost TO mark WITH ADMIN OPTION;

Which two are true? (Choose two.)

Mark can grant the privileges assigned to the r_read@localhost role to another user.

ADMIN OPTION causes the role to be activated by default.

Mark can grant the r_read@localhost role to another user.

Mark can revoke the r_read@localhost role from another role.

ADMIN OPTION allows Mark to drop the role.

Mark must connect from localhost to activate the r_read@localhost role.

1z0-908 PDF/Engine

Get 65% Discount on All Products, Use Coupon: "ac4s65"