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]

SERVEROUTPUT is enabled.

Which is the correct method to use a PACKAGED CONSTANT in SELECT statements?

AOption A

BOption B

COption C

DOption D

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

Sage

5 days ago

This is a tricky one, but I think Option B is the way to go. It's a classic case of 'keep it simple, stupid'. No need to overcomplicate things when a straightforward approach works just fine.

upvoted 0 times

...

Haha, Option D is just asking for trouble! Trying to use a function call to access a constant? That's like trying to eat soup with a fork. Option A is way too complicated, too. I'm going with Option B, no doubt.

upvoted 0 times

...

Dacia

12 days ago

Hmm, I'm not so sure. Option C looks interesting, but I'm worried it might not work if the package name is long or has special characters. Better play it safe with Option B.

upvoted 0 times

...

Kiera

16 days ago

I think Option B is the correct answer. Using the package name and constant name directly in the SELECT statement seems like the most straightforward way to access a packaged constant.

upvoted 0 times

...

Lettie

17 days ago

That's a good point, I didn't consider the performance aspect. Option C might be the better choice then.

upvoted 0 times

...

Gary

18 days ago

I disagree, I believe the correct method is Option C because it provides better performance.

upvoted 0 times

...

Lettie

20 days ago

I think the correct method is to use PACKAGED CONSTANT in SELECT statements is Option A.

upvoted 0 times

...

Oracle Exam 1Z0-149 Topic 1 Question 25 Discussion

Contribute your Thoughts:

Sage

Ulysses

Dacia

Kiera

Lettie

Gary

Lettie