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
You might also like to view...
Most grayscale palettes consist of ____ colors shades of gray.
A. 24 B. 32 C. 100 D. 256
_________ is a language used to query database tables
Fill in the blank(s) with correct word
You must hide formatting marks before printing in order for them not to print on the document
Indicate whether the statement is true or false
You can save your own custom chart as a chart template
Indicate whether the statement is true or false.