Examine the following steps: A DBA grants the CREATE TABLE system privilege with ADMIN OPTION to the user SIDNEY. grants the CREATE TABLE system privilege to the HR user.
SIDNEY - Which statement is true?
A.
SIDNEY can revoke the CREATE TABLE system privilege only from HR, to whom he granted it.
B.
HR can grant the CREATE TABLE system privilege to other users.
C.
Neither SIDNEY nor HR can create new tables if the DBA revokes the CREATE TABLE privilege from SIDNEY.
D.
HR still retains the CREATE TABLE system privilege if the DBA revokes the CREATE TABLE privilege from SIDNEY.
A is correct as well.
The WITH ADMIN OPTION clause gives another user the authority to grant membership in the role to other users, to revoke membership in the role from other members of the role, and to comment on a role, but not to drop the role.
This section is not available anymore. Please use the main Exam Page.1z0-062 Exam Questions
Log in to ExamTopics
Sign in:
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.
ey
Highly Voted 6 years agoonhold
Highly Voted 5 years, 3 months agoRay520
Most Recent 2 years, 11 months agoRay520
2 years, 11 months agoOracle2020
3 years, 8 months agoMRBISS
5 years, 5 months ago