Discuss PostgreSQL PGCES-02 Exam Topic 2 Question 91

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';

Suggested Answer: D

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

30 comments · newest first

Filiberto 6 months ago

E is confusing, not the right approach for this.

Filiberto 6 months ago

B is definitely incorrect. No function called contain.

Elouise 6 months ago

I agree, D is clear and effective.

Kerry 7 months ago

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

Alethea 7 months ago

Yeah, D makes sense. It uses LIKE correctly.

Skye 7 months ago

I think option D is the best choice.

Novella 8 months ago

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

Owen 8 months ago

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

Long 8 months ago

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

Theron 8 months ago

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

Artie 8 months ago

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

Chandra 8 months ago

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

Lore 9 months ago

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

Delmy 9 months ago

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

Antonio 9 months ago

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

Gracie 9 months ago

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

Willetta 9 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.

Earleen 9 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.

Josphine 10 months ago

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

Joanna 10 months ago

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

Dean 10 months ago

D is the right choice!

Hillary 10 months ago

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

Tequila 10 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.

Hollis 11 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.

Temeka 11 months ago

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

Fidelia 5 months ago

↳ replying to Temeka

Makes sense to use LIKE for this situation.

Yoko 5 months ago

↳ replying to Temeka

I like how straightforward it is too.

Lemuel 6 months ago

↳ replying to Temeka

Option D is definitely the way to go!

Danica 6 months ago

↳ replying to Temeka

Yeah, LIKE is perfect for substring searches.

Timothy 6 months ago

↳ replying to Temeka

I agree, option D is clear and effective.

PostgreSQL PGCES-02 Exam - Topic 2 Question 91 Discussion