Oracle Exam 1Z0-909 Topic 9 Question 35 Discussion

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

Question #: 35
Topic #: 9

[All 1Z0-909 Questions]

Examine these statements:

SET collation_connection=utf8mb4_0900_as_cs;

SELECT STRCMPCAlice', UCASE ('Alice* )) ;

What is displayed?

BERROR: 1267 (HYOOO): Illegal mix of collations

C-1

DNULL

Show Suggested Answer

Suggested Answer: B, D

by Isadora at Apr 22, 2024, 08:34 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Lawrence

2 days ago

This question is a real brainteaser! I'm leaning towards B as well, since the collation we're using is explicitly case-sensitive and the strings don't match up.

upvoted 0 times

...

Owen

3 days ago

Alright, time to put my SQL skills to the test. I'm going with B, the error message, because the collation we're using is case-sensitive and the strings don't match exactly.

upvoted 0 times

...

Danica

6 days ago

Haha, I bet the folks who wrote this question were having a field day coming up with these funky collation names. 'utf8mb4_0900_as_cs' sounds like something straight out of a sci-fi novel!

upvoted 0 times

...

Gerardo

13 days ago

Hmm, this one's tricky. I'm guessing the error message in B is the right answer, as the collation we're using doesn't allow for a direct comparison between the two strings.

upvoted 0 times

...

King

14 days ago

I'm not sure, but I think it might be D) NULL since there could be an issue with the collation_connection setting.

upvoted 0 times

...

Bernadine

19 days ago

I believe the correct answer is C) -1 because of the comparison between 'Carey' and 'Carey*'.

upvoted 0 times

...

This question is testing our knowledge of character comparisons with different collations. I think the correct answer is B, since we're using a case-sensitive collation and trying to compare a mixed-case string with an uppercase string.

upvoted 0 times

...

Carey

23 days ago

I think the answer is B) ERROR: 1267 (HYOOO): Illegal mix of collations.

upvoted 0 times

...

Oracle Exam 1Z0-909 Topic 9 Question 35 Discussion

Contribute your Thoughts:

Lawrence

Owen

Danica

Gerardo

King

Bernadine

Freeman

Carey