You know, I was thinking the same thing about option D. It's just too literal. I'm with you guys on option C - that's the most robust and flexible way to handle this kind of partial string match.
Haha, option D. 'John'. That's just silly. As if someone's name would be literally just 'John' with no other characters. These exam questions really try to trip you up sometimes, don't they?
Yeah, I agree with you on option C. The `like` operator is perfect for this kind of partial string match. The other options are too specific - option A would only match exact names of "John", and option D would be case-sensitive, which might not be what the exam is looking for.
Hmm, this seems like a straightforward SQL query, but I want to make sure I understand the nuances. The question is asking us to find the person whose name contains the string "John", so I'd say option C is the way to go. The `like '%John%'` syntax allows us to match any name that has "John" anywhere within it.
upvoted 0 times
...
Log in to Pass4Success
Sign in:
Report Comment
Is the comment made by USERNAME spam or abusive?
Commenting
In order to participate in the comments you need to be logged-in.
You can sign-up or
login
Shayne
7 months agoJenelle
7 months agoLynelle
7 months agoJennifer
7 months agoCiara
7 months agoRutha
7 months agoTequila
7 months agoCharlene
7 months agoElza
7 months ago