In one of your databases, table HR.

Oracle 1z0-149 Question Answer

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.)

Call HR.HELPER.H1 from the HR schema.

Call HR.HELPER.H1 from the SH schema.

Call HR.API.P1 from the HR schema.

Call HR.API.P1 from the SH schema.

Create and call a package procedure API.H1 in the SH schema, which calls HR.HELPER.H1.

Oracle 1z0-149 Summary

Price: $52.5 ~~$149.99~~