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 is not true regarding parameter queries?

A. A parameter query contains a parameter marker in place of a specific value.
B. The WHERE clause of a parameter query can contain more than one parameter marker for the same field.
C. A parameter query will not allow a user to retrieve different records at different times.
D. All of the above


Answer: C

Computer Science & Information Technology

You might also like to view...

Assuming dataFile is a file stream object, the following statement:

dataFile.close(); a. is illegal in C++ b. needs a filename argument to execute cor-rectly c. closes a file d. is legal but risks losing valuable data e. None of these

Computer Science & Information Technology

You can change the number of elements in an array while the application is running using the ____ statement.

A. ReDo B. DoDim C. ReDim D. ReFit

Computer Science & Information Technology

Crosstalk is when a signal transmitted on one copper wire creates an unwanted effect on another wire; the signal "bleeds" over, so to speak

Indicate whether the statement is true or false

Computer Science & Information Technology

Explain the concepts of database entities and attributes.

What will be an ideal response?

Computer Science & Information Technology