PostgreSQL PGCES-02 Exam - Topic 2 Question 91 Discussion

Actual exam question for PostgreSQL's PGCES-02 exam

Question #: 91
Topic #: 2

You want to delete rows in the "product" table which include the value '2004' in the "name" field. Select the correct statement to achieve this task.

ADELETE product WHERE name ~ '2004';

BDELETE product WHERE contain(name, '2004');

CDELETE FROM product WHERE name IN '2004';

DDELETE FROM product WHERE name LIKE '%2004%';

EDELETE FROM product WHERE name SIMILAR TO '2004';

Show Suggested Answer

Suggested Answer: D

by Felicia at Nov 23, 2025, 01:06 AM

Limited Time Offer

25%

Off

Get Premium PGCES-02 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Novella

9 hours ago

B is totally wrong, 'contain' isn't a valid SQL function.

upvoted 0 times

...

Owen

6 days ago

Wait, can you really use LIKE for this? Seems too simple!

upvoted 0 times

...

Long

11 days ago

Ah, the joys of SQL. D) is the winner here, no doubt about it. Time to move on to the next question!

upvoted 0 times

...

Theron

16 days ago

Haha, who writes these exam questions? "contain()" - really? I'll take D) and call it a day.

upvoted 0 times

...

Artie

21 days ago

D) makes the most sense to me. Using LIKE with wildcards is the way to go for this type of task.

upvoted 0 times

...

Chandra

26 days ago

D) is the correct answer. The LIKE operator is used to perform pattern matching on strings.

upvoted 0 times

...

Lore

1 month ago

I thought about option A, but I'm not clear on what the ~ operator does in this context.

upvoted 0 times

...

Delmy

1 month ago

I feel confused about the syntax in option C; it doesn't seem right to use IN like that.

upvoted 0 times

...

Antonio

1 month ago

I remember practicing a similar question, and I think using LIKE with wildcards is common for pattern matching.

upvoted 0 times

...

Gracie

2 months ago

I think the correct answer might be D, but I'm not entirely sure if LIKE is the right operator for this.

upvoted 0 times

...

Willetta

2 months ago

Option D seems like the safest bet here. LIKE is a reliable way to match partial string values, which is what we need to delete the right rows.

upvoted 0 times

...

Earleen

2 months ago

For this type of query, I'd go with the LIKE operator. It's a classic pattern matching approach that I'm familiar with from past exams.

upvoted 0 times

...

Josphine

2 months ago

Definitely going with D, it’s the most straightforward.

upvoted 0 times

...

Joanna

2 months ago

I think A is incorrect, regex isn't needed here.

upvoted 0 times

...

Dean

2 months ago

D is the right choice!

upvoted 0 times

...

Hillary

3 months ago

D) is the way to go. Gotta love those good old LIKE statements with wildcards. Easy peasy!

upvoted 0 times

...

Tequila

3 months ago

Hmm, not sure about some of these options. I'd want to be careful and make sure I'm using the right SQL syntax to avoid any mistakes.

upvoted 0 times

...

Hollis

3 months ago

I'm a bit confused by the different string matching operators like SIMILAR TO and CONTAIN(). Are those standard SQL functions? I'd need to double-check the documentation.

upvoted 0 times

...

Temeka

3 months ago

I think option D looks the most straightforward - using the LIKE operator to match the '2004' substring in the name field.

upvoted 0 times

...