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:

Update Query

A command in database management systems used to modify existing records in the database tables based on specified criteria.

Exclamation Point

A punctuation mark used to express strong feelings or to indicate emphasis.

Red Asterisk

Often used in forms and applications to indicate that a field is required to be filled out by the user.

Red X

A symbol commonly used to represent an error, close a window, or delete.