Which two actions can you perform with object privileges? (Choose two.)
Which two actions can you perform with object privileges? (Choose two.)
With object privileges, you can perform actions such as creating a FOREIGN KEY constraint that references tables in other schemas and executing a procedure or function in another schema. Specifically, the REFERENCES privilege allows the creation of foreign key constraints, and the EXECUTE privilege allows the execution of procedures or functions in other schemas. Creating roles and setting default and temporary tablespaces for a user are system privileges, not object privileges. Deleting rows from tables generally requires the DELETE object privilege, although the DELETE ANY TABLE privilege is a system privilege.
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
As per your source: Privilege: DELETE; Description: Enables a user to delete from a table.. Privilege: REFERENCES; Enables a user to create a foreign key dependency on a table or materialized view So, BC
A is wrong because : Create Role is a system privilege
BE for me, please update the answers
ADE is system privileges
Delete is an onject privilege, same as execute, I think B and E are correct, please correct me if I'm wrong
DELETE ANY TABLE : Enables a user to delete from any table in the database . -> this is a System privileges that is different from the object privilege DELETE that enables a user to delete from a table. Than the correct answer are BE
You can delete from a table under sys schema if object priv is granted
`BE is correct
should be bE
B and E. A can not be correct cause it is system privilege.
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.
BE for me
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.