1Z0-071 Joining Multiple Tables

Question 1

Which JOIN type returns all rows from the left table and matching rows from the right table, with NULLs for non-matches?

Accepted Answer

LEFT OUTER JOIN

Answer

INNER JOIN

Answer

FULL OUTER JOIN

Answer

CROSS JOIN

Question 2

What is the result of a CROSS JOIN between a table with 4 rows and a table with 3 rows?

Accepted Answer

12 rows

Answer

4 rows

Answer

3 rows

Answer

7 rows

Question 3

Which SQL syntax represents an ANSI-standard INNER JOIN?

Accepted Answer

SELECT * FROM a JOIN b ON a.id = b.id

Answer

SELECT * FROM a, b WHERE a.id = b.id

Answer

SELECT * FROM a INNER b WHERE a.id = b.id

Answer

SELECT * FROM a, b ON a.id = b.id

Question 4

What is a NATURAL JOIN in Oracle SQL?

Accepted Answer

A join that uses all columns with the same name in both tables

Answer

A join using a WHERE clause only

Answer

A join that always returns all rows from both tables

Answer

A join specified with a USING clause

Question 5

Which clause in a JOIN allows you to specify a single common column name without a table prefix?

Accepted Answer

USING

Answer

ON

Answer

WHERE

Answer

BY

Question 6

What type of join returns rows from both tables regardless of whether a match exists?

Accepted Answer

FULL OUTER JOIN

Answer

INNER JOIN

Answer

LEFT OUTER JOIN

Answer

RIGHT OUTER JOIN