Oracle Exam 1Z0-909 Topic 4 Question 58 Discussion

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

Question #: 58
Topic #: 4

[All 1Z0-909 Questions]

Examine this statement and output:

You execute this statement:

SELECT JSON_SEARCH(product,'one','IT') FROM fshop ;

What is the output?

Aproduct->''$.varieties [4]. origin[1];;

B''$.varieties[4]. origin[1]''

Cproduct->varieties[3]. origin[0]''

D''$.varieties [3]. origin[0]''

Show Suggested Answer

Suggested Answer: A

by Dana at Mar 08, 2025, 01:40 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

1 months ago

Haha, this question is a real JSON riddle. I'm gonna go with option B, but part of me wants to just guess 'D' for the comedy factor.

upvoted 0 times

...

1 months ago

This question is a real brain-teaser, but I reckon option B is the one that'll get me the points. Time to show off my JSON expertise!

upvoted 0 times

...

1 months ago

Ah, the old JSON search trick! I'm confident option B is the way to go here. Gotta love those JSON paths.

upvoted 0 times

8 days ago

I agree, JSON search can be confusing. Option B seems like the most logical choice.

upvoted 0 times

...

19 days ago

I think option B is correct too. JSON paths can be tricky sometimes.

upvoted 0 times

...

2 months ago

I think the correct answer is B.

upvoted 0 times

...