A set of tables are defined as follows: t1 t2 How many rows are returned by executing the following SQL statement? SELECT * FROM t1 LEFT OUTER JOIN t2 USING (id);

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

Data Management and SQL

Question

A set of tables are defined as follows:

t1 t2 How many rows are returned by executing the following SQL statement? SELECT * FROM t1 LEFT OUTER JOIN t2 USING (id);

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.

Unlock PGCES-02 - $49.99 / 30 days Sign in

Topics

#LEFT OUTER JOIN#SQL joins#USING clause#result set size

Full PGCES-02 Practice