Exam 1z0-071 topic 1 question 39 discussion

BE A : False. Creating role is system privilege. B : True. Use REFERENCE privilege. C : False. Use DELETE ANY TABLE system privilege. D : False? E : True. Use EXECUTE privilege.

B, E - correct see description in the table 7-2 https://docs.oracle.com/database/121/TTSQL/privileges.htm#TTSQL341

ANSWER BC

SELECT * FROM DBA_SYS_PRIVS; SELECT * FROM user_tab_privs;

B. Correct. To create foreign key constraints in one schema that reference tables in another schema, you must have appropriate object permissions on the target table, such as the REFERENCES permission. This is a typical application of object permissions. E Correct. Executing a procedure or function in another schema requires having the EXECUTE permission on that procedure or function, which is also a type of object permission.

`BE is correct

should be bE

B and E. A can not be correct cause it is system privilege.

BE for me, please update the answers

You can delete from a table under sys schema if object priv is granted

System privileges allow a user to perform a particular database operation or class of database operations. For example, to create a table, the user needs the create table privilege. Objects have privileges associated with them, such as insert, update and delete a table.

A is wrong because : Create Role is a system privilege

ADE is system privileges

A You must have the CREATE ROLE system privilege. B Object privileges REFERENCES object type Table or materialized view Enables a user to create a foreign key dependency on a table or materialized view. The REFERENCES privilege on a parent table implicitly grants SELECT privilege on the parent table C System privileges DELETE ANY TABLE Enables a user to delete from any table in the database. D I think it’s System privileges E Object privileges: Object type PL/SQL package, procedure or function; Enables a user to execute a PL/SQL package, procedure or function directly.

Delete is an onject privilege, same as execute, I think B and E are correct, please correct me if I'm wrong