Case 1 - LuvUrPet
the Database for a Pet Supply

question 52

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 allows the user to provide an ItemNum to select a record to delete from the dataset.Which function must also be used in the code for the Delete button on the form to work properly?

• A)INSERT
• B)InsertRecordQuery
• C)DELETE
• D)DeleteRecordQuery

---

Definitions:

Mutual Ownership

A form of ownership where an organization is owned by its members or customers, often seen in cooperative businesses or mutual insurance companies.

Consolidation

The process of combining the financial statements of separate companies, subsidiaries, or divisions, into single financial statements that represent the total assets, liabilities, equity, income, expenses, and cash flows of the parent company.

Ownership Interest

A share or stake in an entity that gives the holder a claim on part of the entity's assets and profits.