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

Gayla

3 months ago

The answer is obviously E) 6 rows. Why? Because the more options, the better the chances of guessing correctly, right? *winks*

upvoted 0 times

Kenny

1 months ago

I'm sticking with E) 6 rows, more options means better chances!

upvoted 0 times

...

Krystina

1 months ago

No, I'm pretty sure it's 5 rows.

upvoted 0 times

...

Edelmira

1 months ago

I think the answer is actually 4 rows.

upvoted 0 times

...

Quentin

3 months ago

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

upvoted 0 times

Janine

30 days ago

I believe it's D) 5 rows.

upvoted 0 times

...

Benton

1 months ago

I agree with C) 4 rows.

upvoted 0 times

...

Viola

1 months ago

I'm going with B) 3 rows.

upvoted 0 times

...

Aaron

2 months ago

I think it's A) 2 rows.

upvoted 0 times

...

Shawnta

3 months 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

3 months 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

3 months 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

Leanna

2 months ago

Yes, you're right. The LEFT OUTER JOIN will return all rows from t1 table.

upvoted 0 times

...

Audra

3 months ago

I think it's 4 rows

upvoted 0 times

...

Buddy

3 months ago

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

upvoted 0 times

...

Luis

3 months ago

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

upvoted 0 times

...

Tijuana

4 months ago

I think the answer is B) 3 rows.

upvoted 0 times

...