Case 1 - MaidToOrder
the Database for a Cleaning Service

question 24

Multiple Choice

Case 1 - MaidToOrder
The database for a cleaning service company contains the following table, named tblCustomer, that includes customer invoice data. The InvoiceNum, CustomerNum, and InvoicePaid fields contain text. The InvoiceDate field contains dates. The InvoiceAmt field contains numbers.
$$\begin{array} { | l | l | l | l | l | } \hline \text { InvoiceNum } & \text { CustomerNum } & \text { InvoiceDate } & \text { InvoiceAmt } & \text { InvoicePaid } \\\hline 631 & 13020 & 01 / 15 / 2013 & 200.00 & \mathrm { Y } \\\hline 632 & 15411 & 01 / 20 / 2013 & 685.00 & \mathrm { Y } \\\hline 633 & 10002 & 01 / 23 / 2013 & 75.00 & \mathrm {~N} \\\hline 634 & 13104 & 01 / 23 / 2013 & 150.00 & \mathrm {~N} \\\hline 635 & 12124 & 01 / 26 / 2013 & 75.00 & \mathrm { Y } \\\hline 636 & 13328 & 02 / 02 / 2013 & 350.00 & \mathrm { Y } \\\hline 637 & 10206 & 02 / 02 / 2013 & 175.00 & \mathrm {~N} \\\hline 638 & 10334 & 02 / 07 / 2013 & 450.00 & \mathrm { Y } \\\hline\end{array}$$
-Which of the following statements will calculate a total for all of the unpaid invoices?

• A)Dim decTotalUnpaid =Aggregate customer In CustomerDataSet.tblCustomerSelect customer.InvoicePaid Into Sum()
• B)Dim decTotalUnpaid =Aggregate customer In CustomerDataSet.tblCustomerSelect customer.InvoiceAmt Into Sum()
• C)Dim decTotalUnpaid =Aggregate customer In CustomerDataSet.tblCustomerWhere customer.InvoicePaid.ToUpper = "N"Select customer.InvoiceAmt Into Average()
• D)Dim decTotalUnpaid =Aggregate customer In CustomerDataSet.tblCustomerWhere customer.InvoicePaid.ToUpper = "N"Select customer.InvoiceAmt Into Sum()

Comprehend the concepts of threats and promises and factors influencing their effectiveness.

Understand how proximity affects obedience to authority.

Recognize that obedience to authority can produce both positive and negative outcomes.

Understand different app functionalities and their alignment with consumer needs.

---

Definitions:

Blood Pressure

The pressure of circulating blood against the walls of blood vessels, considered vital for human life.

High-density Lipoprotein

Often referred to as "good" cholesterol, it helps to remove other forms of cholesterol from the bloodstream.

Congestive Heart Failure

A chronic condition in which the heart does not pump blood as well as it should, leading to a buildup of fluid in the body.

Percutaneous Transluminal Coronary Angioplasty

A minimally invasive procedure to open up blocked coronary arteries, allowing blood to circulate to the heart muscle.