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 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?

Show Suggested Answer Hide Answer
Suggested Answer: B, D

Contribute your Thoughts:

Lawrence
2 months 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
Glennis
16 days ago
C) -1
upvoted 0 times
...
Monte
22 days ago
B) ERROR: 1267 (HYOOO): Illegal mix of collations
upvoted 0 times
...
Gregoria
1 months ago
A) 0
upvoted 0 times
...
...
Owen
2 months 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
2 months 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
Catalina
7 days ago
C) -1
upvoted 0 times
...
Catalina
8 days ago
B) ERROR: 1267 (HYOOO): Illegal mix of collations
upvoted 0 times
...
Catalina
13 days ago
A) 0
upvoted 0 times
...
...
Gerardo
2 months 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
Ciara
2 months ago
User 2: Yeah, that makes sense. The collation_connection and the comparison function don't match up.
upvoted 0 times
...
Nadine
2 months ago
User 1: I think it's B) ERROR: 1267 (HY000): Illegal mix of collations
upvoted 0 times
...
...
King
2 months 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
2 months ago
I believe the correct answer is C) -1 because of the comparison between 'Carey' and 'Carey*'.
upvoted 0 times
...
Freeman
2 months ago
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
Marshall
1 months ago
C) -1
upvoted 0 times
...
Edna
2 months ago
B) ERROR: 1267 (HYOOO): Illegal mix of collations
upvoted 0 times
...
Odette
2 months ago
A) 0
upvoted 0 times
...
...
Carey
3 months ago
I think the answer is B) ERROR: 1267 (HYOOO): Illegal mix of collations.
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