Oracle Exam 1Z0-909 Topic 3 Question 40 Discussion

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

Question #: 40
Topic #: 3

[All 1Z0-909 Questions]

The collection col contains all episodes for all seasons for a TV show.

Examine this document which has an example of the details for each episode:

Which query returns all expisode names from the first season?

ASELECT doc->'$.name' FROM col WHERE doc->'$.season' = '1';

BSELECT 'S.name' FROM col WHERE 'S.season' = '1';

CSELECT doc-,,$.name,, FROM col WHERE doc-'$ . season' = '1';

DSELECT name FROM col WHERE season = 1;

Show Suggested Answer

Suggested Answer: B, D

by Malcolm at Jun 21, 2024, 01:07 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Vincent

13 days ago

Option D seems to be the correct answer. The query selects the 'name' field directly from the collection, and the 'season' condition is specified without the need for the JSON path syntax.

upvoted 0 times

...

Earnestine

17 days ago

But A uses the correct syntax to access the season and name fields.

upvoted 0 times

...

Ashleigh

18 days ago

I disagree, I believe the answer is D.

upvoted 0 times

...

Earnestine

21 days ago

I think the correct answer is A.

upvoted 0 times

...