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...
Which of the following topics is covered under the information security governance and risk management CBK domain?
A. Understanding forensic procedures B. Following compliance requirements C. Developing and implementing security policies D. Understanding the fundamental concepts of security models
How many steps are involved in the process of deleting a node?
a. one: delete the node from memory b. two: remove the node without breaking links, then delete it from memory c. three: create a blank node, remove the node being deleted, insert the blank node d. four: create a blank node, insert the blank node before the node being deleted, remove the node being deleted, delete the blank node e. None of these