New Year Sale Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: simple70

  1. Home
  2. Discussions
  3. Oracle
  4. Oracle Database PL/SQL Developer Certified Professional
  5. 1z0-149 Discussions
  6. 1z0-149 Exam Topic 2 Question 17 Discussion

Oracle Database 19c: Program with PL/SQL 1z0-149 Question # 17 Topic 2 Discussion

 Oracle Discussions      Browse All Questions      Go to Exam Detail      Get Premium Access
 Previous
Next  

Oracle Database 19c: Program with PL/SQL 1z0-149 Question # 17 Topic 2 Discussion

1z0-149 Exam Topic 2 Question 17 Discussion:
Question #: 17
Topic #: 2

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:

1z0-149 Question 17

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.

Get Premium 1z0-149 Questions
Actual exam question for Oracle 1z0-149 exam by Vega7391 at Aug 2, 2025, 12:00:00 AM

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.

Submit
 Previous
Next