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
An application using the dataset should allow a user to type in a price to use to query the dataset. Which of the following clauses would allow a user to select the records for collars with a price of 15 or more?
A. WHERE Price = 15
B. WHERE Price Like 15
C. WHERE Price >= @Price
D. WHERE Price < @Price
Answer: C
You might also like to view...
Which of the following is not an abstract implementation provided by the collections framework?
a. AbstractCollection. b. AbstractTree. c. AbstractMap. d. AbstractList.
Objects can be placed on a hidden layer.
Answer the following statement true (T) or false (F)
A(n) ________ structures information in columns and rows on a slide
Fill in the blank(s) with correct word
_____ is a network of physical objects embedded with sensors, processors, software, and network connectivity capability to enable them to exchange data with the manufacturer, operator, and other connected devices.
a. The Internet of Digital divide b. The Internet of Things c. The Internet of Data d. The Internet of Regulations