PrepAway - Latest Free Exam Questions & Answers

Which of the following types of joins will you use to accomplish this?

You work as a Database Administrator for Dolliver Inc. The company uses an Oracle database.
The database contains two tables, named Employees and Departments. You want to retrieve all
matched and unmatched rows from both the tables. Which of the following types of joins will you
use to accomplish this?

PrepAway - Latest Free Exam Questions & Answers

A.
FULL OUTER JOIN

B.
LEFT OUTER JOIN

C.
RIGHT OUTER JOIN

D.
CROSS JOIN

Explanation:

One Comment on “Which of the following types of joins will you use to accomplish this?


Leave a Reply

Your email address will not be published. Required fields are marked *