PostgreSQL_CE
PGCES-02 · Question #5
The tables "t1" and "t2" are defined below. Tables "t1" and "t2" have columns "id" that are of INTEGER type, and columns "name" that are of TEXT type. t1 t2 The following SQL command was executed…
The correct answer is B. 3 rows. See the full explanation below for the reasoning.
Question
The tables "t1" and "t2" are defined below. Tables "t1" and "t2" have columns "id" that are of INTEGER type, and columns "name" that are of TEXT type. t1 t2 The following SQL command was executed. Select the number of rows in the result. SELECT * FROM t1 RIGHT OUTER JOIN t2 ON t1.id = t2.id;
Options
- A2 rows
- B3 rows
- C4 rows
- D5 rows
- E6 rows
How the community answered
(28 responses)- A11% (3)
- B79% (22)
- C4% (1)
- E7% (2)
Community Discussion
No community discussion yet for this question.