Oracle Exam 1Z0-149 Topic 1 Question 25 Discussion

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

Question #: 25
Topic #: 1

[All 1Z0-149 Questions]

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 Domingo at Apr 30, 2024, 02:21 PM

Limited Time Offer

25%

Off

Get Premium 1Z0-149 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Robt

6 months ago

Good point, but isn't the point just to find which calls execute successfully using the existing privileges?

upvoted 0 times

...

Maryanne

6 months ago

But what about option E? Can't SH create and call a procedure within its own schema?

upvoted 0 times

...

Rozella

7 months ago

I agree with user3, option D makes sense. SH can definitely call HR.API.P1.

upvoted 0 times

...

Carla

7 months ago

Not sure about C. I think D is more likely correct because SH has that EXECUTE privilege.

upvoted 0 times

...

Goldie

7 months ago

Yeah, especially with the EXECUTE privileges. I think A and C should be correct.

upvoted 0 times

...

Robt

7 months ago

This question on the test really got me thinking.

upvoted 0 times

...