1Z0-007 Question #43: Real Exam Question with Answer & Explanation

The correct answer is E. It allows the grantee to grant object privileges to other users and roles.. The GRANT command with the WITH GRANT OPTION clause allows the grantee to grant object privileges to other users and roles. Incorrect Answers A: The WITH GRANT OPTION does not allow a grantee DBA privileges. B: It is not required syntax for object privileges. It is optional claus

Question

What is true about the WITH GRANT OPTION clause?

Options

AIt allows a grantee DBA privileges.
BIt is required syntax for object privileges.
CIt allows privileges on specified columns of tables.
DIt is used to grant an object privilege on a foreign key column.
EIt allows the grantee to grant object privileges to other users and roles.

Explanation

The GRANT command with the WITH GRANT OPTION clause allows the grantee to grant object privileges to other users and roles. Incorrect Answers A: The WITH GRANT OPTION does not allow a grantee DBA privileges. B: It is not required syntax for object privileges. It is optional clause of GRANT command. C: GRANT command does not allows privileges on columns of tables. D: It is not used to grant an object privilege on a foreign key column.

Community Discussion

No community discussion yet for this question.

Full 1Z0-007 Practice