What is true about the following query:select $*$ from departments minusSELECT DEPARTMENT$\_$ID$,$DEPARTMENT NAME,MANAGER ID$,$LOCATION ID FROM DEPARTMENTS;Use the following definition of the departments table:COLUMN$\_$NAMEDATA$\_$TYPEDEPARTMENT ID NUMBER$(4,0)$NoDEPARTMENT NAME VARCHAR$2(30$ BYTE$)$NoMANAGER ID NUMBER$(6,0)$YesLOCATION ID NUMBER$(4,0)$Yes$.$ The query returns all the departments without duplicates.Query executes successfullyQuery returns an empty result setThe execution throws an error because there is a mismatch between the columns of the subqueries.