New Year Sale 2026! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

PostgreSQL PGCES-02 Exam - Topic 2 Question 91 Discussion

Actual exam question for PostgreSQL's PGCES-02 exam
Question #: 91
Topic #: 2
[All PGCES-02 Questions]

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.

Show Suggested Answer Hide Answer
Suggested Answer: D

Contribute your Thoughts:

0/2000 characters
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
...

Save Cancel