A table named Emp is given below that contains dataof an organization.
How many records will be displayed if the followingSQL query is executed? SELECT *
FROM Emp
WHERE Name BETWEEN ‘D’ AND ‘F’
A.
2
B.
A character column cannot be used in the BETWEEN operator.
C.
3
D.
4
Explanation:
The table given below shows the result of the query. The character column is compared against a stringusing
the BETWEEN operator, which is
equivalent to >= ‘D’ AND <=’F’. The name Flora willnot be included because Flora is > F.
