examine the commands used to create DEPARTMENT_DETAILS and COURSED_ETAILS:
You want to generate a report that shows all course IDs irrespective of whether they have corresponding department IDs or not but no department IDs if they do not have any courses.
Which SQL statement must you use?
A. Option A
B. Option B
C. Option C
D. Option D
|
Download Printable PDF. VALID exam to help you PASS. |
 |
A should be the answer, but,
In A, there is syntax error, comma in front of FROM keyword.
In B, there is syntax error, period (.) after the FROM keyword.
In D, logic is incorrect as it using “not equal to”.
The right response is A
A is not correct because it’s missing table aliases for the course_id and department_id columns.
A
A
A
A
https://stackoverflow.com/questions/51885433/full-outer-join-brain-dumps
A
why not A , it seems the correct answer