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
11 months agoJenelle
10 months agoLynelle
10 months agoJennifer
10 months agoCiara
10 months agoRutha
10 months agoTequila
11 months agoCharlene
11 months agoElza
11 months ago