Oracle Database SQL — Question 6

Which two actions can you perform with object privileges? (Choose two.)

Answer options

• A. Create roles.
• B. Create FOREIGN KEY constraints that reference tables in other schemas.
• C. Delete rows from tables in any schema except SYS.
• D. Set default and temporary tablespaces for a user.
• E. Execute a procedure or function in another schema.

Correct answer: B, E

Explanation

The correct options are B and E because object privileges specifically allow users to create FOREIGN KEY constraints that refer to tables in different schemas and to execute procedures or functions in other schemas. Options A, C, and D are not actions that can be performed using object privileges; they relate to different administrative functions or privileges.