Discuss PostgreSQL PGCES-02 Exam Topic 2 Question 1

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

ASELECT 'ABC' . 'abc';

BSELECT cat('ABC', 'abc') FROM pg_operator;

CSELECT 'ABC' + 'abc';

DSELECT 'ABC' + 'abc' FROM pg_operator;

ESELECT 'ABC' || 'abc';

Suggested Answer: E

Get Premium PGCES-02 Questions as Interactive Web-Based Practice Test or PDF Real Exam Format Detailed Explanations Instant Access Get Your Practice Test

13 comments · newest first

Reta 11 months ago

No way, I thought '+' worked for concatenation too!

Marget 11 months ago

Wait, can you really use cat() in SQL? That seems odd.

Ronald 12 months ago

E is correct! The double pipe operator is the standard for concatenation.

Skye 12 months ago

I thought it was A at first, but that's not valid syntax.

Micaela 12 months ago

It's definitely E, that's the right way to concatenate in SQL!

Laine 1 year ago

I feel like option A is definitely wrong, but I can't remember if `cat()` is the right function or if it's just `||` that we should use.

Lorrine 1 year ago

I practiced a similar question where we used `cat()` in PostgreSQL, but I don't recall if that's the right syntax here.

Leanna 1 year ago

I'm not entirely sure, but I remember something about using `+` for concatenation in some databases. Could it be option C?

Jin 1 year ago

I think the concatenation operator in SQL is usually `||`, so maybe option E is correct?

Isaiah 1 year ago

Ah, this is a classic cloud security question. The key is integrations - these tools need to be able to connect to all your cloud accounts and third-party services to get a full view. I'm pretty sure the answer is APIs, but I'll double-check my notes just to be safe.

Ulysses 1 year ago

I'm pretty sure the answer is B - read/write/execute. That's the standard file permissions we've been learning about.

Dusti 1 year ago

I practiced a similar question, and I think it was RADIUS and TACACS+, but now I'm second-guessing if there's something else like sFlow involved.

Lonny 1 year ago

I'm a little confused on this one. Is it really that simple? I feel like there could be some tricky logic behind the "most consistent with lower inventories" part. I'll have to think this through carefully.

PostgreSQL PGCES-02 Exam - Topic 2 Question 1 Discussion