Examine the description of the COUNTRIES table:
Examine the description of the DEPARTMENTS table:
Examine the description of the LOCATIONS table:
Which two queries will return a list of countries with no departments? (Choose two.)
Exam 1z0-071 All QuestionsBrowse all questions from this exam
Question 219
Correct Answer: B, D
To list countries with no departments, we can use different strategies. Option B uses a MINUS set operation to subtract the list of countries with departments from the list of all countries, effectively leaving us with those that have no departments. Option D uses a subquery to exclude countries that have any associated departments. Both approaches ensure that only countries without any departments are returned.
Discussion
McromeoOptions: BD
BD correct
NB196Options: BD
How are BD correct? Since B, C & D are only selecting country_id and country_name they only return a list of countries with no departments. Could someone please explain this
mrcsp
The question asks for countries with NO department