Microsoft
98-364 · Question #25
A table named Emp is given below that contains data of an organization. How many records will be displayed if the following SQL query is executed? - SELECT * - FROM Emp - WHERE Name BETWEEN 'D' AND…
The correct answer is C. 3. See the full explanation below for the reasoning.
Question
A table named Emp is given below that contains data of an organization. How many records will be displayed if the following SQL query is executed?
- SELECT *
- FROM Emp
- WHERE Name BETWEEN 'D' AND 'F'
Exhibit
Options
- A2
- BA character column cannot be used in the BETWEEN operator.
- C3
- D4
How the community answered
(20 responses)- B5% (1)
- C85% (17)
- D10% (2)
Community Discussion
No community discussion yet for this question.