A: Incorrect: INITCAP changes the first character of the extracted last name to uppercase and the rest to lowercase. However, this does not work for "MC" because INITCAP would change it to "Mc."
B:Correct: This extracts the last name and matches it directly against "Mc%" (case-sensitive). This works because "Mc" is explicitly matched.
D: Correct: UPPER ensures that both the extracted last name and the pattern are converted to uppercase, making the comparison case-insensitive. This matches both "Mc" and "MC."
This section is not available anymore. Please use the main Exam Page.1z0-071 Exam Questions
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Thameur01
2 months, 3 weeks agolucemqy
5 months agozouve
10 months agoNelita
10 months, 3 weeks agokuff
11 months, 2 weeks agopmeyer
11 months, 3 weeks agoPoke90
1 year agoRik92
1 year, 1 month agogreenneem
1 year, 2 months agodexdinh91
1 year, 3 months agoViviana3184
1 year, 3 months agoBabi265
1 year, 4 months ago