Exam 1z0-149 topic 1 question 49 discussion

Actual exam question from Oracle's 1z0-149

Question #: 49
Topic #: 1

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

A. Call HR.HELPER.H1 from the HR schema.
B. Call HR.HELPER.H1 from the SH schema.
C. Call HR.API.P1 from the HR schema.
D. Call HR.API.P1 from the SH schema.
E. Create and call a package procedure API.H1 in the SH schema, which calls HR.HELPER.H1.

Show Suggested Answer

Suggested Answer: CD 🗳️

by jfc1 at July 5, 2023, 5:27 p.m.

Comments

Submit Cancel

Festo

Highly Voted 4 months, 4 weeks ago

Correct answer is C,D

upvoted 5 times

...

jfc1

Highly Voted 5 months, 1 week ago

Selected Answer: CD

I think C,D is the Correct answer

upvoted 5 times

...

thranduyl

Most Recent 5 days, 1 hour ago

Selected Answer: CD

CD y es correct

upvoted 1 times

...

egznrd

3 months, 2 weeks ago

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

upvoted 4 times

...

Exam 1z0-149 All Questions

View all questions & answers for the 1z0-149 exam