In one of your databases, table HR.EMPLOYEES includes the columns FIRST_NAME and EMPLOYEE_ID.
A row exists with EMPLOYEE_ID 201.
Examine these packages created by user HR:
EXECUTE privilege is granted to user SH, on the HR.API and HR.HELPER packages.
Which two will execute successfully? (Choose two.)
The EXECUTE privilege allows the SH user to call procedures defined in the HR schema. However, because the HR.HELPER package has the procedure HR.HELPER.H1 marked as accessible only by the HR.API package, a direct call to HR.HELPER.H1 by user SH will not be successful. Therefore, user SH must invoke HR.API.P1, which internally calls HR.HELPER.H1. This means the procedure within the HR.HELPER package can be executed indirectly via the HR.API package. Hence, the correct executions involve calling HR.API.P1 from both the HR and SH schemas.
Correct answer is C,D
I think C,D is the Correct answer
Correct answer is C,D. because the user cannot call proctected procedure directly https://docs.oracle.com/en/database/oracle/oracle-database/19/lnpls/ACCESSIBLE-BY-clause.html#GUID-9720619C-9862-4123-96E7-3E85F240FF36
CD y es correct