Case 1 - LuvUrPet
the Database for a Pet Supply

question 10

Multiple Choice

Case 1 - LuvUrPet
The 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.
$$\begin{array} { | l | l | l | l | l | } \hline \text { ItemNum } & \text { ItemDesc } & \text { Color } & \text { Price } & \text { Quantity } \\\hline 2358 & \text { leather collar } & \text { black } & 25.00 & 35 \\\hline 2693 & \text { leather collar } & \text { brown } & 25.00 & 25 \\\hline 3547 & \text { striped collar } & \text { red } & 15.00 & 75 \\\hline 3855 & \text { striped collar } & \text { blue } & 15.00 & 42 \\\hline 3764 & \text { striped collar } & \text { green } & 15.00 & 48 \\\hline 5782 & \text { solid collar } & \text { pink } & 12.00 & 36 \\\hline 5785 & \text { solid collar } & \text { red } & 12.00 & 10 \\\hline 5787 & \text { solid collar } & \text { blue } & 12.00 & 15 \\\hline\end{array}$$
-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 >= ?
• D)WHERE Price < ?

---

Definitions:

Bushel of Corn

A unit of measure for volumes of dry commodities, used especially for grain, equivalent to approximately 35.24 liters.

Price Support Program

A government policy aimed at maintaining the market price of a good at a certain level to ensure that producers receive a minimum income from their products.

Efficiency Loss

A reduction in optimal resource allocation, often resulting from market distortions such as taxes or monopolies.

Taxpayers' Burden

The financial obligations imposed on taxpayers, such as taxes and public debt, required to fund government operations and obligations.