Question: If , given the SQL statement SELECT EmpName FROM EMPLOYEE WHERE DeptID 7 OR DeptID > 1 2 then which of the following is true?

If, given the SQL statement
SELECT EmpName
FROM EMPLOYEE
WHERE DeptID 7 OR DeptID >12
then which of the following is true? Assume each employee can only have one department.
DeptIDs 1 through 6 are excluded from the results set, but DeptIDs 7 through 12 are included in the results set
all results are included in the results set
DeptIDs 1 through 6 are included from the results set, DeptIDs 7 through 11 are excluded in the results set, and all departments >12 are included
no results are included in the results set
 If, given the SQL statement SELECT EmpName FROM EMPLOYEE WHERE DeptID

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!