nerdexam
PostgreSQL_CE

PGCES-02 · Question #98

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 follow

Sign in or unlock PGCES-02 to reveal the answer and full explanation for question #98. The question stem and answer options stay visible for context.

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

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.

Full PGCES-02 Practice