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 clauses would allow a user to select the records for collars with a cost of between 10 and 20?
A. WHERE Price >= @Price1 AND Price <= @Price2
B. WHERE @Price1 < Query < @Price2
C. WHERE Price <= 10 AND Price >= 20
D. WHERE Price LIKE 10 AND Price LIKE 20
Answer: A
You might also like to view...
Where in the Hyper-V architecture do device drivers reside?
A. Hypervisor B. Parent partition C. Child partition D. Hardware
If you use someone else's work without permission or credit and pass it off as your own work, you are ________ the work
Fill in the blank(s) with correct word
Microsoft Word's Outline view displays the hierarchy of the document's data
Indicate whether the statement is true or false
____ includes the techniques and physical barriers used to protect computers and information from attacks that do not originate electronically.
A. Physical security B. Network security C. Virtual security D. Intermediate security