MENU
The "sample" table consists of the following data: How many rows are returned by executing the following SQL statement? SELECT * FROM sample WHERE v ~ 'ab';
Suggested Answer: C
Get Premium PGCES-02 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
12 comments · newest first
LE
Leonida
3 days ago
I’m leaning towards 2 rows based on my last run.
CH
Cherry
8 days ago
Definitely not 0 rows, there must be at least 1 match.
NE
Nettie
13 days ago
I think it depends on the data in the "sample" table.
ME
Merilyn
18 days ago
Wait, are you sure it even matches anything?
LO
Lonna
23 days ago
I agree, 1 row sounds about right.
AN
Andra
28 days ago
No way it's 4 rows, that seems too high!
MU
Muriel
1 month ago
I'm pretty sure it's 2 rows based on the regex match.
LI
Lisandra
1 month ago
I think it depends on the actual data in the "sample" table.
VE
Verdell
1 month ago
I remember something about how the regex can match multiple occurrences, but I can't recall the exact data. I'm leaning towards 1 row.
VE
Velda
2 months ago
I'm not entirely sure, but I think if 'ab' appears in any of the values, it could return multiple rows. Could it be 3?
MA
Margery
2 months ago
I feel like we practiced a similar question in class, and it was about counting rows with specific patterns. Maybe it's 2 rows?
KA
Kate
2 months ago
I think the regex operator `~` is used for pattern matching, but I can't remember how it works with the data in the table.