You work as a Database Administrator for Dolliver Inc.

Vendor: Zend
Product: 100-500
Update on: Jul 25, 2025
Questions: 202

Zend 100-500 Question Answer

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?

FULL OUTER JOIN

LEFT OUTER JOIN

RIGHT OUTER JOIN

CROSS JOIN