PostgreSQL_CE
PGCES-02 · Question #17
The "sample" table consists of the data below. The column "x" is of type INTEGER. How many PostgreSQL CE PGCES-02 Exam rows are returned by executing the following SQL statement? SELECT 6 / x FROM…
The correct answer is D. 2 rows. See the full explanation below for the reasoning.
Question
The "sample" table consists of the data below. The column "x" is of type INTEGER. How many PostgreSQL CE PGCES-02 Exam rows are returned by executing the following SQL statement? SELECT 6 / x FROM sample WHERE CASE WHEN x = 0 THEN FALSE ELSE TRUE END;
Options
- A"ERROR division by zero" and no rows are returned.
- B0 rows with no errors.
- C1 row
- D2 rows
- E3 rows
How the community answered
(40 responses)- A5% (2)
- B3% (1)
- D83% (33)
- E10% (4)
Community Discussion
No community discussion yet for this question.