MENU
A set of tables are defined as follows: t1 t2 How many rows are returned by executing the following SQL statement? SELECT t1.name FROM t1 CROSS JOIN t2;
Suggested Answer: A, 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
28 comments · newest first
LO
Louann
10 months ago
I disagree, it should be more than that!
KR
Krystina
11 months ago
I think it's 2 rows based on the tables.
KA
Kami
11 months ago
Wait, are there really 6 rows? Sounds too high.
AD
Adelle
11 months ago
Definitely going with 6 rows!
LO
Louis
11 months ago
It's a CROSS JOIN, so it multiplies the rows.
PA
Pansy
12 months ago
I’m pretty sure if either table is empty, it would return 0 rows, but I need to double-check the row counts in t1 and t2.
MA
Marlon
12 months ago
I feel like I might be mixing up CROSS JOIN with INNER JOIN. Does CROSS JOIN always return all combinations?
AR
Arlene
12 months ago
I remember practicing a similar question, and I think if t1 has 2 rows and t2 has 3, the result would be 6 rows.
LE
Leslie
1 year ago
I think a CROSS JOIN returns all combinations of rows from both tables, but I'm not sure how many rows are in t1 and t2.
DO
Dorcas
1 year ago
Hmm, I'm a bit stuck on this one. I know CROSS JOIN is used to combine rows from two tables, but I'm not sure how to predict the exact number of rows returned. I'll need to review some examples and practice more CROSS JOIN problems to get a better feel for this.
MI
Mica
1 year ago
This is a tricky one. The key is understanding how CROSS JOIN works - it generates all possible combinations of rows from the two tables. Without knowing the actual table sizes, I'll have to think through the possible scenarios to determine the most likely answer.
WH
Whitney
1 year ago
Okay, I've got this. The CROSS JOIN will combine each row from t1 with each row from t2, so the number of rows returned will be the product of the number of rows in each table. If there's no information given about the table sizes, I'll have to make an educated guess.
LE
Leah
1 year ago
Hmm, I'm a bit unsure about this one. I know CROSS JOIN returns the Cartesian product of the two tables, but I'm not sure how to calculate the exact number of rows. I'll need to review the concept again.
NA
Naomi
1 year ago
This looks like a straightforward CROSS JOIN question. I'll think through the logic step-by-step to determine the number of rows returned.
DO
Dong
1 year ago
Wait, did they say the tables are defined as 't1' and 't2'? I thought this was a database exam, not a magic trick!
AR
Arminda
1 year ago
Ah, a good old-fashioned CROSS JOIN! This is a classic SQL question. I'm going with E, just to keep things interesting.
CU
Curtis
1 year ago
I'm going with E) 6 rows.
NO
Nohemi
1 year ago
I believe it's C) 3 rows.
SH
Shantell
1 year ago
I'm going with B) 2 rows.
LE
Lemuel
1 year ago
I think it's A) 0 rows.
MA
Maira
1 year ago
Hmm, I'm not sure about this one. I'll have to think it through carefully. Maybe I should call the Help Desk for a hint?
CL
Clemencia
1 year ago
I think the answer is D. A CROSS JOIN will return the Cartesian product of the two tables, so the number of rows returned will be the number of rows in t1 multiplied by the number of rows in t2.
MA
Mabelle
1 year ago
I'm pretty sure it's B.
RO
Roxane
1 year ago
No, I believe the answer is E.
TI
Tijuana
1 year ago
I think the answer is D.
RA
Rashida
2 years ago
Why do you think it's 3 rows?
HE
Helga
2 years ago
I disagree, I believe the answer is C) 3 rows.
RA
Rashida
2 years ago
I think the answer is B) 2 rows.