Case-Based Critical Thinking Questions

?
Case 1: LuvUrPetThe database for a pet supply company includes the following table, named tblCollar, that contains product data for pet collars. The ItemDesc and Color fields contain text. The ItemNum, Price, and Quantity fields contain numbers.
ItemNum
ItemDesc
Color
Price
Quantity
2358
leather studded collar
black
30.00
35
2693
leather collar
brown
25.00
25
3547
striped collar
red
20.00
75
3855
striped collar
blue
15.00
42
3764
striped collar
green
15.00
48
5782
solid collar
pink
12.00
36
5785
solid collar
red
12.00
10
5787
solid collar
blue
10.00
15
Which of the following statements would select the ItemDesc and Price fields from tblCollar for all records whose ItemDesc field begins with the word "leather" followed by zero or more characters?

A. SELECT ItemDesc, Price FROM tblCollar    WHERE ItemDesc LIKE leather %
B. SELECT ItemDesk FROM tblCollar     WHERE ItemDesc LIKE 'leather %'
C. GET ItemDesc, Price FROM tblCollar    WHERE ItemDesc LIKE 'leather %'
D. SELECT ItemDesc, Price FROM tblCollar    WHERE ItemDesc LIKE 'leather %'

Answer: D