Oracle Exam 1Z0-909 Topic 3 Question 36 Discussion

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

Question #: 36
Topic #: 3

[All 1Z0-909 Questions]

Examine this statement which executes successfully:

SET @ir := 2;

Which query updates the value of @r to 0?

ASELECT 'Car' REGEXP('Ca?') >= 0 INTO @r;

BSELECT STRCMP('Car'/Ca?') >= 0 INTO @r;

CSELECT 'Car' LIKE 'Ca?' INTO @r;

DSELECT 'Car' RLIKE 'Ca?' INTO @r;

Show Suggested Answer

Suggested Answer: A, B

by Luisa at May 02, 2024, 04:02 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Daron

5 hours ago

Haha, this is like a game of SQL Jeopardy! I'll go with option B, because STRCMP is always a safe bet when you're not sure.

upvoted 0 times

...

Kerrie

12 days ago

Hmm, this is a tricky one. I'm going to go with option D just to be different. Who knows, maybe the instructor is trying to trick us!

upvoted 0 times

...

Clemencia

14 days ago

I'm pretty sure the REGEXP function in option A is the way to go here. Regular expressions are the way to handle pattern matching in SQL.

upvoted 0 times

...

Laquita

16 days ago

I'm not sure, but I think A) SELECT 'Car' REGEXP('Ca?') >= 0 INTO @r might also work.

upvoted 0 times

...

Edna

17 days ago

I agree with Ivette, because the LIKE operator is used for pattern matching in SQL.

upvoted 0 times

...

Arminda

19 days ago

The correct answer is C. 'Car' LIKE 'Ca?' will return 1, which updates the value of @r to 0.

upvoted 0 times

...

Ivette

23 days ago

I think the correct answer is C) SELECT 'Car' LIKE 'Ca?' INTO @r.

upvoted 0 times

...