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

12 days 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

15 days 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

Lemuel

1 days ago

I think it's A) 0 rows.

upvoted 0 times

...

Maira

18 days 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

23 days 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