nerdexam
PostgreSQL_CE

PGCES-02 · Question #98

PGCES-02 Question #98: Real Exam Question with Answer & Explanation

The correct answer is D. 5 rows. See the full explanation below for the reasoning.

Question

The tables "t1" and "t2" are defined below. The tables "t1" and "t2" have columns "id" which are type of INTEGER and column "name"s which PostgreSQL CE PGCES-02 Exam are type of TEXT. t1 t2 The following SQL command was executed. Select the number of rows in the result. SELECT * FROM t1 NATURAL FULL OUTER JOIN t2;

Options

  • A2 rows
  • B3 rows
  • C4 rows
  • D5 rows
  • E6 rows

Community Discussion

No community discussion yet for this question.

Full PGCES-02 Practice