Case 1 - LuvUrPet
the Database for a Pet Supply

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}$$
-You must first ____ to begin creating a SQL query.

A) start the TableAdapter Query Configuration Wizard
B) right-click the CollarsDataSet.xsd file, then click Open to open the DataSet Designer window
C) choose a query type
D) specify a SQL SELECT statement