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()

---

Definitions:

Neurologic Recheck

A repeated examination to assess changes in a patient's neurological status.

Neurologic Examination

A series of tests conducted to assess the nervous system's functioning, including muscle strength, reflexes, balance, and sensation.

Central

Pertaining to the center or most important part of an object, area, or function.

Peripheral

Relating to or situated on the edge or periphery of something; in medical terms, it often refers to the outer regions of the body, such as the limbs.