Question

C. The concatenation operator is .......​

Answer 1

Answer:

Concatenation operator joins multiple strings into a single string.

There are two concatenation operator, + and &. Both carry the concatenation operator.

Answer 2

A concatenation operator [||] is used for appending two string.

Explanation:

The concatenation operator in SQL is a kind of binary operator. The symbolic representation of the concatenation operator is ‘||’.  

It is used for appending or concatenating two expressions which evaluate the ‘character data types’ or to the numeric data types.  

We cannot use the ‘concatenation operator’ directly to data types such as user defined ‘data types’ or ‘large object data types’ or ‘number data types’ or other operands with built in characters.