Oracle
1Z0-074 · Question #59
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 cascading. Explanation/Reference: https://docs.oracle.com/cd/B28359_01/network.111/b28531/authorization.htm#DBSEG004
New Features for Security
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 privilege
- 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 cascading
- FWITH GRANT OPTION cannot be used when granting an object privilege to PUBLIC
How the community answered
(65 responses)- A71% (46)
- B15% (10)
- D5% (3)
- F9% (6)
Explanation
Explanation/Reference: https://docs.oracle.com/cd/B28359_01/network.111/b28531/authorization.htm#DBSEG004
Topics
#object privileges#system privileges#WITH GRANT OPTION#privilege revocation
Community Discussion
No community discussion yet for this question.