Q: 3
[Data Ingestion and Integration]
What will be the output of the function below?
L_TRIM("a* aapple", "a")
Options
Discussion
A . Had something like this in a mock, and L_TRIM only removes the 'a' characters from the left, not spaces or anything else. The first char is 'a', then '*' stays, so you're left with ' aapple' as output. Let me know if someone disagrees but this matches what I've seen in labs.
D imo, but pretty sure that's a trap. If the trim set was different I'd say C, but not confident here.
A. similar question was in the official guide and practice tests.
Nah, I think A here. L_TRIM just strips out the leading 'a' character, so the output is space + 'aapple'. B's trap is thinking quotes are part of the output, but they're not.
Probably A. The L_TRIM function here just removes the leading 'a', nothing else, so the output would still have the space and asterisk in front of aapple. Not 100% sure if there's some edge case but that's how I see it. Disagree?
Just to clarify, are people maybe confusing the trim set here? If you specify only "a" as the trim char in L_TRIM, it won’t remove the space or special chars, just any leading 'a's. So the result wouldn’t be B or C, unless they change the trim set to include more chars.
Option B
A
A imo. The trap is B but the space doesn't get trimmed since only 'a' is in the trim set. L_TRIM just strips 'a' from the left, leaves the space. Anyone see it different?
B
Be respectful. No spam.
