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

Filiberto

2 months ago

E is confusing, not the right approach for this.

upvoted 0 times

...

Filiberto

2 months ago

B is definitely incorrect. No function called contain.

upvoted 0 times

...

Elouise

2 months ago

I agree, D is clear and effective.

upvoted 0 times

...

Kerry

2 months ago

Option A is wrong, regex isn't needed here.

upvoted 0 times

...

Alethea

2 months ago

Yeah, D makes sense. It uses LIKE correctly.

upvoted 0 times

...

Skye

2 months ago

I think option D is the best choice.

upvoted 0 times

...

Novella

3 months ago

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

upvoted 0 times

...

Owen

3 months ago

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

upvoted 0 times

...

Long

3 months 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

4 months ago

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

upvoted 0 times

...

Artie

4 months 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

4 months ago

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

upvoted 0 times

...

Lore

4 months ago

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

upvoted 0 times

...

Delmy

4 months ago

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

upvoted 0 times

...

Antonio

4 months ago

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

upvoted 0 times

...

Gracie

5 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

5 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

5 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

5 months ago

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

upvoted 0 times

...

Joanna

5 months ago

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

upvoted 0 times

...

Dean

5 months ago

D is the right choice!

upvoted 0 times

...

Hillary

6 months ago

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

upvoted 0 times

...

Tequila

6 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

6 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

6 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

Fidelia

20 days ago

Makes sense to use LIKE for this situation.

upvoted 0 times

...

Yoko

25 days ago

I like how straightforward it is too.

upvoted 0 times

...

Lemuel

1 month ago

Option D is definitely the way to go!

upvoted 0 times

...

Danica

1 month ago

Yeah, LIKE is perfect for substring searches.

upvoted 0 times

...

Timothy

1 month ago

I agree, option D is clear and effective.

upvoted 0 times

...