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.