Q. What does 'abc' || 'xyz', when PIPES_AS_CONCAT is enabled, result in?
-
(A)
0
-
(B)
64
-
(C)
abcxyz
-
(D)
xyzabc
✅ Correct Answer: (C)
abcxyz
Explanation: This question is about how MySQL handles the double pipe (||) operator when a special setting called PIPES_AS_CONCAT is enabled.