Examine the commands used to create DEPARTMENT_DETAILS and COURSE_DETAILS tables:
You want to generate a list of all department IDs that do not exist in the COURSE_DETAILS table.
You execute the SQL statement:
What is the outcome?
A. It fails because the join type used is incorrect.
B. It executes successfully and displays the required list.
C. It executes successfully but displays an incorrect list.
D. It fails because the ON clause condition is not valid.
C
C
С is answer
B
C