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

Quentin

2 days ago

Definitely C) 4 rows. I'm so confident about this that I'm already planning my victory dance.

upvoted 0 times

...

Shawnta

3 days ago

Wow, this is a tricky one! I'm going to go with D) 5 rows. Who knows, maybe there's some hidden magic in the database that'll surprise us all.

upvoted 0 times

...

Carri

5 days ago

I'm pretty sure the answer is B) 3 rows. The LEFT OUTER JOIN will only return the rows where there is a match between the two tables.

upvoted 0 times

...

Nieves

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

17 days ago

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

upvoted 0 times

...

Luis

19 days ago

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

upvoted 0 times

...

Tijuana

24 days ago

I think the answer is B) 3 rows.

upvoted 0 times

...