PostgreSQL_CE
PGCES-02 · Question #13
PGCES-02 Question #13: Real Exam Question with Answer & Explanation
Sign in or unlock PGCES-02 to reveal the answer and full explanation for question #13. The question stem and answer options stay visible for context.
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
Unlock PGCES-02 to see the answer
You've previewed enough free PGCES-02 questions. Unlock PGCES-02 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.