nerdexam
PostgreSQL_CE

PGCES-02 · Question #48

A set of tables are defined as follows: t1 PostgreSQL CE PGCES-02 Exam t2 How many rows are returned by executing the following SQL statement? SELECT t1.name FROM t1 CROSS JOIN t2;

The correct answer is E. 6 rows. See the full explanation below for the reasoning.

Question

A set of tables are defined as follows:

t1 PostgreSQL CE PGCES-02 Exam t2 How many rows are returned by executing the following SQL statement? SELECT t1.name FROM t1 CROSS JOIN t2;

Options

  • A0 rows
  • B2 rows
  • C3 rows
  • D5 rows
  • E6 rows

How the community answered

(16 responses)
  • A
    6% (1)
  • B
    19% (3)
  • D
    6% (1)
  • E
    69% (11)

Community Discussion

No community discussion yet for this question.

Full PGCES-02 Practice