Independence Day Deal! Unlock 25% OFF Today – Limited-Time Offer - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

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?

Show Suggested Answer Hide Answer
Suggested Answer: A, B

Contribute your Thoughts:

Lasandra
2 months ago
Wait, what? I thought we were supposed to be setting @ir, not @r. These database questions are making my head spin!
upvoted 0 times
Cornell
11 days ago
Yeah, that's right. Option C) is the one that updates @r to 0.
upvoted 0 times
...
Larue
19 days ago
I think the correct query to update @r to 0 is option C) SELECT 'Car' LIKE 'Ca?' INTO @r.
upvoted 0 times
...
Rene
1 months ago
I know, these database queries can be confusing sometimes.
upvoted 0 times
...
...
Daron
2 months 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
2 months 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
Shenika
1 months ago
Let's see if the answer is option D.
upvoted 0 times
...
Angelica
1 months ago
I agree with you, I also think it's option D.
upvoted 0 times
...
Skye
2 months ago
I'm not sure, but I think it might be option A.
upvoted 0 times
...
Margot
2 months ago
I'm not sure, but I'll choose option A just to be safe.
upvoted 0 times
...
Junita
2 months ago
I think option D is correct.
upvoted 0 times
...
Roxane
2 months ago
I think option D is correct too. Let's see if we're right!
upvoted 0 times
...
...
Clemencia
2 months 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
2 months ago
I'm not sure, but I think A) SELECT 'Car' REGEXP('Ca?') >= 0 INTO @r might also work.
upvoted 0 times
...
Edna
2 months ago
I agree with Ivette, because the LIKE operator is used for pattern matching in SQL.
upvoted 0 times
...
Arminda
2 months ago
The correct answer is C. 'Car' LIKE 'Ca?' will return 1, which updates the value of @r to 0.
upvoted 0 times
Odette
24 days ago
Actually, the correct answer is C) SELECT 'Car' LIKE 'Ca?' INTO @r;
upvoted 0 times
...
Tambra
26 days ago
I'm pretty sure it's D) SELECT 'Car' RLIKE 'Ca?' INTO @r;
upvoted 0 times
...
Shala
1 months ago
No, I believe it's C) SELECT 'Car' LIKE 'Ca?' INTO @r;
upvoted 0 times
...
Herminia
1 months ago
I think the correct answer is A) SELECT 'Car' REGEXP('Ca?') >= 0 INTO @r;
upvoted 0 times
...
...
Ivette
2 months ago
I think the correct answer is C) SELECT 'Car' LIKE 'Ca?' INTO @r.
upvoted 0 times
...

Save Cancel
az-700  pass4success  az-104  200-301  200-201  cissp  350-401  350-201  350-501  350-601  350-801  350-901  az-720  az-305  pl-300  

Warning: Cannot modify header information - headers already sent by (output started at /pass.php:70) in /pass.php on line 77