PostgreSQL_CE
PGCES-02 · Question #13
The tables "s1" and "s2" are defined below. The column "id" for tables "s1" and "s2" is of INTEGER type. The column "enable" for table "s1" is Of BOOLEAN type, and the column "name" for table "s2"…
The correct answer is B. 2 rows. PostgreSQL CE PGCES-02 Exam
Data Management and SQL
Question
The tables "s1" and "s2" are defined below. The column "id" for tables "s1" and "s2" is of INTEGER type. The column "enable" for table "s1" is Of BOOLEAN type, and the column "name" for table "s2" is of TEXT type. s1:
id | enable ----+-------- 1 | t 2 | f s2:
id | name ----+------ 1 | post 2 | gre 3 | SQL The following SQL was executed. Select the correct number of rows in the result. SELECT * FROM s2 WHERE id IN (SELECT id FROM s1);
Options
- A1 row
- B2 rows
- C3 rows
- D4 rows
- E5 rows
How the community answered
(36 responses)- A8% (3)
- B72% (26)
- C14% (5)
- D3% (1)
- E3% (1)
Explanation
PostgreSQL CE PGCES-02 Exam
Topics
#SQL subquery#IN clause#row selection#query results
Community Discussion
No community discussion yet for this question.