Oracle Exam 1Z0-149 Topic 14 Question 19 Discussion

Actual exam question for Oracle's 1Z0-149 exam

Question #: 19
Topic #: 14

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

ACall HR.HELPER.H1 from the HR schema.

BCall HR.HELPER.H1 from the SH schema.

CCall HR.API.P1 from the HR schema.

DCall HR.API.P1 from the SH schema.

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

Show Suggested Answer

Suggested Answer: B, D

by Trinidad at Jan 26, 2024, 12:19 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!