Q100
'abc' || 'xyz', when PIPES_AS_CONCAT is enabled, results in . . . . . . . .
A.
0
B.
1
C.
abcxyz
AnswerD.
xyzabc
Answer: Option C
Solution
Answer: Option C
Solution:
When the PIPES_AS_CONCAT SQL mode is enabled in MySQL, the || operator is interpreted as the concatenation operator. Therefore, the expression 'abc' || 'xyz' results in 'abcxyz'. Hence, the correct option is Option C: abcxyz.