Case 1 - LuvUrPet
the Database for a Pet Supply

question 27

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

---

Definitions:

Pure-Breeding

Refers to organisms that, when bred, produce offspring with specific, uniform characteristics over many generations.

Incompletely Dominant

A genetic scenario wherein the phenotype of the heterozygote is intermediate between those of the two homozygotes.

Stumpy

Describes an object, limb, or structure that is short and thick in proportion to its length, often used in describing plant or animal features.

Methylation Patterns

Biological processes involving the addition of a methyl group to DNA, affecting gene expression without changing the sequence.