Oracle Database SQL 12c 1z0-071 Exam Practice Test 4

Question : 33 of 57

Marks: +1, -0

Which three are true about system and object privileges? (Choose three.)

WITH GRANT OPTION can be used when granting an object privilege to both users and roles
Adding a primary key constraint to an existing table in another schema requires a system privilege
Adding a foreign key constraint pointing to a table in another schema requires the REFERENCES object privilege
Revoking a system privilege that was granted with WITH ADMIN OPTION has a cascading effect
Revoking an object privilege that was granted with the WITH GRANT OPTION clause has a cascading effect.
WITH GRANT OPTION cannot be used when granting an object privilege to PUBLIC

Go to Question:

Prev Question

Next Question