Oracle Exam 1Z0-149 Topic 1 Question 10 Discussion

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

Question #: 10
Topic #: 1

Examine these statements:

Which is true?

AIt will result in a compilation error for protected_proc because calling_proc does not exist.

BIt will result in a compilation error for protected_proc because calling_proc must be prefixed with the schema name.

CIt will result in a successful compilation because objects referenced in an ACCESSIBLE BY clause are not checked at compile time.

DWith adequate privileges, PROTECTED_PROC procedure can be called by other programs apart from CALLING_PROC.

Show Suggested Answer

Suggested Answer: A, D

by Erick at Jul 04, 2023, 05:51 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Abel

2 months ago

But doesn't the question mention that objects referenced in an ACCESSIBLE BY clause are not checked at compile time?

upvoted 0 times

...

Bettye

2 months ago

Hmm, I was leaning towards option D, but Denae makes a good point. The ACCESSIBLE BY clause is more about runtime access control than compile-time checks. Time to review my notes on that one.

upvoted 0 times

Jodi

3 hours ago

But doesn't option D also make sense? With adequate privileges, PROTECTED_PROC procedure can be called by other programs apart from CALLING_PROC.

upvoted 0 times

...

Armando

5 days ago

I think option C is correct. Objects referenced in an ACCESSIBLE BY clause are not checked at compile time.

upvoted 0 times

...

Frank

27 days ago

Looks like we need to review our notes on this topic to be sure.

upvoted 0 times

...

Germaine

28 days ago

True, but the ACCESSIBLE BY clause is more about runtime access control. It won't result in a compilation error.

upvoted 0 times

...

Justine

2 months ago

But what about option D? With adequate privileges, PROTECTED_PROC procedure can be called by other programs apart from CALLING_PROC.

upvoted 0 times

...

Remona

2 months ago

I think option C is correct. Objects referenced in an ACCESSIBLE BY clause are not checked at compile time.

upvoted 0 times

...

Chana

2 months ago

I disagree, I believe the correct answer is D.

upvoted 0 times

...

Abel

2 months ago

I think the correct answer is C.

upvoted 0 times

...

Han

2 months ago

But the question mentions that objects referenced in an ACCESSIBLE BY clause are not checked at compile time, so I still think C is the correct answer.

upvoted 0 times

...

Britt

2 months ago

I agree with Denae. The ACCESSIBLE BY clause is more about runtime permissions than compile-time checks. It's a common gotcha that tripped me up in the past too.

upvoted 0 times

Leatha

2 months ago

D) With adequate privileges, PROTECTED_PROC procedure can be called by other programs apart from CALLING_PROC.

upvoted 0 times

...

Tommy

2 months ago

A) It will result in a successful compilation because objects referenced in an ACCESSIBLE BY clause are not checked at compile time.

upvoted 0 times

...

Erasmo

2 months ago

I disagree, I believe the answer is D.

upvoted 0 times

...

Han

2 months ago

I think the correct answer is C.

upvoted 0 times

...

Denae

2 months ago

Option C is the correct answer. The ACCESSIBLE BY clause is not checked at compile-time, so the procedure can be called by any program with the appropriate privileges.

upvoted 0 times

Rolf

1 months ago

Exactly, as long as the necessary privileges are granted, the procedure can be called by other programs.

upvoted 0 times

...

Veronica

1 months ago

So, it doesn't matter if calling_proc exists or not, as long as the privileges are there.

upvoted 0 times

...

Janna

1 months ago

That makes sense, the ACCESSIBLE BY clause allows the procedure to be called by any program with the right privileges.

upvoted 0 times

...

Ettie

2 months ago

I think the correct answer is C) It will result in a successful compilation because objects referenced in an ACCESSIBLE BY clause are not checked at compile time.

upvoted 0 times

...