Case 1 - LuvUrPet
the Database for a Pet Supply

question 24

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}$$
-Which of the following is not true regarding the Query Builder?

• A)The table and its related fields are displayed in the Diagram pane.
• B)You cannot view the results of the query in the Query Builder once it is executed.
• C)You can manually type the SELECT statement instead of using the Query Builder.
• D)You must click the Execute Query button for the query to run.

---

Definitions:

Variable Costs

Expenses that directly fluctuate in relation to production or business operations volume.

Maintenance Hours

Maintenance hours tally the time spent on maintaining and repairing equipment, machinery, or systems, crucial for ensuring operational efficiency and longevity.

Return On Investment (ROI)

A financial ratio used to measure the profitability of an investment, calculated by dividing the net profit from the investment by its initial cost.

Residual Income

The income that remains after deducting all required costs of capital and operating expenses from net income.