Oracle
1Z0-071 · Question #347
Which three are true about system and object privileges? (Choose three.)
The correct answer is A. WITH GRANT OPTION can be used when granting an object privilege to both users and roles C. Adding a foreign key constraint pointing to a table in another schema requires the REFERENCES E. Revoking an object privilege that was granted with the WITH GRANT OPTION clause has a. https://docs.oracle.com/cd/B28359_01/network.111/b28531/authorization.htm#DBSEG004
Controlling User Access
Question
Which three are true about system and object privileges? (Choose three.)
Options
- AWITH GRANT OPTION can be used when granting an object privilege to both users and roles
- BAdding a primary key constraint to an existing table in another schema requires a system
- CAdding a foreign key constraint pointing to a table in another schema requires the REFERENCES
- DRevoking a system privilege that was granted with WITH ADMIN OPTION has a cascading effect
- ERevoking an object privilege that was granted with the WITH GRANT OPTION clause has a
- FWITH GRANT OPTION cannot be used when granting an object privilege to PUBLIC
How the community answered
(25 responses)- A84% (21)
- B8% (2)
- D4% (1)
- F4% (1)
Explanation
https://docs.oracle.com/cd/B28359_01/network.111/b28531/authorization.htm#DBSEG004
Topics
#system privileges#object privileges#WITH GRANT OPTION#cascading revoke
Community Discussion
No community discussion yet for this question.