'abc' || 'xyz', when PIPES_AS_CONCAT is enabled, results in . . . . . . . .
A. 0
B. 1
C. abcxyz
D. xyzabc
Answer: Option C
Solution(By Examveda Team)
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.Related Questions on MySQL Miscellaneous
How is communication established with MySQL?
A. SQL
B. Network calls
C. A programming language like C++
D. APIs
Which type of database management system is MySQL?
A. Object-oriented
B. Hierarchical
C. Relational
D. Network
Join The Discussion