Exit PGCES-02 PostgreSQL CE 8 Silver
Question 5 of 5
0% complete
Q5 Single choice

The table "custom" is defined below.
The "id" column and "introducer" column are of INTEGER type, and the "email" column is of TEXT type. id | email | introducer
----+-----------------+------------
2 | [email protected] | 1
3 | [email protected] | 2
4 | [email protected] | 2
Three SQL statements were executed in the following order: UPDATE custom SET email = '' FROM custom c WHERE custom.introducer = c.id; UPDATE custom SET introducer = NULL WHERE introducer NOT IN
(SELECT id FROM custom); DELETE FROM custom WHERE id = 2 OR introducer = 2;
Select the number of rows in the "custom" table after the execution.

  • A

    0 rows

  • B

    1 row

  • C

    2 rows

  • D

    3 rows

  • E

    4 rows