PostgreSQL_CE

PGCES-02 · Question #84

Select the correct SQL statement which concatenates strings 'ABC' and 'abc' to form 'ABCabc'.

The correct answer is E. SELECT 'ABC' || 'abc'. See the full explanation below for the reasoning.

Question

Select the correct SQL statement which concatenates strings 'ABC' and 'abc' to form 'ABCabc'.

Options

ASELECT'ABC' . 'abc';
BSELECTcat('ABC', 'abc') FROM pg_operator;
CSELECT 'ABC' + 'abc';
DSELECT 'ABC' + 'abc' FROM pg_operator;
ESELECT 'ABC' || 'abc';

How the community answered

(26 responses)

A
15% (4)
C
4% (1)
D
4% (1)
E
77% (20)

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion

Full PGCES-02 Practice