PostgreSQL Exam PGCES-02 Topic 4 Question 80 Discussion

Actual exam question for PostgreSQL's PGCES-02 exam

Question #: 80
Topic #: 4

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;

A0 rows

B2 rows

C3 rows

D5 rows

E6 rows

Show Suggested Answer

Suggested Answer: A, C

by Marnie at Jan 22, 2025, 11:49 AM

Limited Time Offer

25%

Off

Get Premium PGCES-02 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Dong

2 months ago

Wait, did they say the tables are defined as 't1' and 't2'? I thought this was a database exam, not a magic trick!

upvoted 0 times

...

Arminda

2 months ago

Ah, a good old-fashioned CROSS JOIN! This is a classic SQL question. I'm going with E, just to keep things interesting.

upvoted 0 times

Curtis

22 days ago

I'm going with E) 6 rows.

upvoted 0 times

...

Nohemi

29 days ago

I believe it's C) 3 rows.

upvoted 0 times

...

Shantell

1 months ago

I'm going with B) 2 rows.

upvoted 0 times

...

Lemuel

2 months ago

I think it's A) 0 rows.

upvoted 0 times

...

Maira

2 months 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?

upvoted 0 times

...

Clemencia

2 months 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.

upvoted 0 times