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

Peter

28 days ago

I wonder if the TV show is 'Game of Thrones' and the episode names are all just variations of 'Winter is Coming'.

upvoted 0 times

Phil

16 days ago

D) SELECT name FROM col WHERE season = 1;

upvoted 0 times

...

Barbra

17 days ago

I don't think the TV show is 'Game of Thrones', but that query looks correct.

upvoted 0 times

...

Cruz

19 days ago

A) SELECT doc->\'$.name\' FROM col WHERE doc->\'$.season\' = \'1\';

upvoted 0 times

...

Alyce

1 months ago

Options B and C just look plain wrong. Who uses double quotes for field names in SQL? That's just silly.

upvoted 0 times

...

Alysa

1 months ago

Hold on, guys. Option A also looks like it could work, using the JSON path syntax to access the 'name' and 'season' fields. But I guess Option D is a bit cleaner.

upvoted 0 times

Tamesha

2 days ago

Let's go with Option D then, it's the most efficient.

upvoted 0 times

...

Brittney

6 days ago

Yeah, Option D is definitely more straightforward.

upvoted 0 times

...

Cecily

10 days ago

I agree, but Option D is simpler and cleaner.

upvoted 0 times

...

Caprice

18 days ago

Option A seems like a good choice, it uses JSON path syntax to access the fields.

upvoted 0 times

...

Sommer

2 months ago

I agree with Vincent. Option D is the most straightforward and efficient way to retrieve the episode names from the first season.

upvoted 0 times

Eric

12 days ago

Yeah, option D seems like the simplest solution.

upvoted 0 times

...

Jacki

14 days ago

I agree, option D is definitely the most efficient.

upvoted 0 times

...

Dahlia

19 days ago

I think option D is the best choice.

upvoted 0 times

...

Vincent

2 months 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