PostgreSQL Exam PGCES-02 Topic 8 Question 57 Discussion

Actual exam question for PostgreSQL's PGCES-02 exam

Question #: 57
Topic #: 8

The "sample" table consists of the following data: How many rows are returned by executing the following SQL statement? SELECT DISTINCT ON (data) * FROM sample;

A2 rows

B3 rows

C4 rows D. 5 rows

E6 rows

Show Suggested Answer

Suggested Answer: C

by Irma at Mar 21, 2024, 05:56 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Norah

6 days ago

Oh, I was sure it was D. 5 rows. But now I'm not so sure. I need to review my SQL basics again.

upvoted 0 times

...

Quiana

10 days ago

I think the correct answer is B. 3 rows. The DISTINCT ON clause will return the first row for each distinct value of the 'data' column.

upvoted 0 times

...

Joseph

12 days ago

I agree with Catalina, the answer is C) 4 rows. The DISTINCT ON clause will return unique values based on the specified column.

upvoted 0 times

...

Catalina

14 days ago

I disagree, I believe the answer is C) 4 rows because DISTINCT ON eliminates duplicates.

upvoted 0 times

...

Darrin

18 days ago

I think the answer is B) 3 rows.

upvoted 0 times

...