Case-Based Critical Thinking Questions Case 1 - MaidToOrder

question 24

Multiple Choice

Case-Based Critical Thinking Questions 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.
Which of the following statements will calculate a total for all of the unpaid invoices?

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

---

Definitions:

Resonance Structures

Representations of a molecule where the chemical connectivity is the same but the electrons are distributed differently around the structure.

Cyclic

Pertaining to chemical compounds that contain a ring structure within their molecules.

Lewis Structure

A diagrammatic method for representing the valence electrons of atoms within a molecule, indicating bonds between them.

Ozone

A molecule made of three oxygen atoms, O3, forming a layer in the Earth's stratosphere that protects life by absorbing most of the sun's harmful ultraviolet radiation.