SOLVED: Which of the following scenarios requires a FULL OUTER JOIN?

Which of the following scenarios requires a FULL OUTER JOIN?

You want to find all employees who either have a project assigned or not assigned.

You need to find unmatched rows from both employee and department tables.

You want to find matching rows only from both tables.

You want to include all rows from one table, regardless of matching conditions.

Verified Answer

Correct Option - b

To get all Infosys Certified Oracle Database Administrator - Beginner Exam questions Join Telegram Group https://grateful.prepflix.in/infy-lex-pdfs