Question 1 of 30
In a database containing two tables, `Employees` and `Departments`, you want to retrieve a comprehensive list of all employees along with their respective department names. Some employees may not belong to any department, and some departments may not have any employees assigned to them. If you execute a FULL OUTER JOIN on these two tables using the `DepartmentID` as the joining key, what will be the result set in terms of the data returned?
The result will include all employees and all departments, with NULLs in the department name for employees without a department and NULLs in the employee details for departments without employees.
The result will include only employees who belong to a department, excluding those without a department.
The result will include only departments that have employees assigned to them, excluding departments without employees.
The result will include all employees and only those departments that have at least one employee assigned to them.

Preparing for Microsoft 98-364 Database Fundamentals? Now land the interview.

73% of qualified candidates get rejected because of weak resumes. Build an ATS-optimized, recruiter-ready resume in under 5 minutes - free to start.

Build My Resume Free