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:

Utility Function

A representation of how consumer preferences over a set of goods and services are ordered, indicating the level of satisfaction derived from different bundles of goods.

Consumption

The action or process of using up goods and services, typically by households.

Utility Function

It is an economic model representing the preference level of consumers for different combinations of goods and services.

Income

A measure of the flow of funds from various sources, such as wages, investments, or business activities, that an individual or entity receives over a period of time.