PostgreSQL Exam PGCES-02 Topic 1 Question 79 Discussion

Actual exam question for PostgreSQL's PGCES-02 exam

Question #: 79
Topic #: 1

A set of tables are defined as follows: t1 t2 How many rows are returned by executing the following SQL statement? SELECT * FROM t1 LEFT OUTER JOIN t2 USING (id);

A2 rows

B3 rows

C4 rows

D5 rows

E6 rows

Show Suggested Answer

Suggested Answer: A, E

by Janessa at Jan 11, 2025, 08:27 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Nieves

29 minutes ago

The correct answer is C) 4 rows. The LEFT OUTER JOIN will return all rows from the t1 table, even if there are no matching rows in the t2 table.

upvoted 0 times

...

Buddy

8 days ago

I believe the answer is C) 4 rows, as it includes all rows from t1 and t2.

upvoted 0 times

...

Luis

10 days ago

I agree with Tijuana, because there are 2 rows in t1 and 1 row in t2.

upvoted 0 times

...

Tijuana

15 days ago

I think the answer is B) 3 rows.

upvoted 0 times

...