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

Recognize the impact of the Great Schism and the Avignon Papacy on the authority of the Pope and the Catholic Church.

Identify the causes and effects of the Protestant Reformation on European society and politics.

Explain the concept of predestination and its importance in Calvinist doctrine.

Describe the role of the Act of Supremacy in establishing the Church of England and its significance for Henry VIII's reign.

---

Definitions:

American Medical Association

A professional association of physicians in the United States dedicated to promoting the art and science of medicine and the betterment of public health.

Binomially Distributed

A probability distribution of a variable that represents the number of successes in a fixed number of independent trials, with only two possible outcomes.

Random Variable

A random variable is a variable whose values are outcomes of a random phenomenon.

Sporting Goods Store

A retail establishment specializing in the sale of sports equipment, outdoor gear, and related merchandise.