nerdexam
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)
  • A
    8% (3)
  • B
    72% (26)
  • C
    14% (5)
  • D
    3% (1)
  • E
    3% (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.

Full PGCES-02 Practice