Oracle
1Z0-071 · Question #347
Which three are true about system and object privileges? (Choose three.)
Sign in or unlock 1Z0-071 to reveal the answer and full explanation for question #347. The question stem and answer options stay visible for context.
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
Unlock 1Z0-071 to see the answer
You've previewed enough free 1Z0-071 questions. Unlock 1Z0-071 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#system privileges#object privileges#WITH GRANT OPTION#cascading revoke