Which three are true about system and object privileges? (Choose three.)
A.
WITH GRANT OPTTON cannot be used when granting an object privilege to PUBLIC.
B.
WITH GRANT OPTION can be used when granting an object privilege to both users and roles.
C.
Revoking an object privilege that was granted with the WITH GRANT OPTION clause has a cascading effect. C. Adding a primary key constraint to an existing table in another schema requires a system privilege.
D.
Adding a foreign key constraint pointing to a table in another schema requires the REFERENCES object privilege.
E.
Revoking a system privilege that was granted with WITH ADMIN OPTION has a cascading effect.
Adding a primary key constraint to an existing table in another schema requires a system privilege - is this not correct. It requires an Object Privilage.
ACD for me
E is not correct
http://www.dba-oracle.com/t_with_grant_admin_privileges.htm
upvoted 1 times
...
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.
kay000001
2 months, 2 weeks agokay000001
2 months, 2 weeks agoogi33
7 months, 1 week agotom100men
9 months, 1 week agotom100men
9 months, 1 week ago