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:

Brand Purpose

The reason a brand exists beyond making a profit, often encapsulating its ideals, contributions to society, and the value it aims to add to customers' lives.

Ethical Challenges

The moral dilemmas and issues that arise in the context of business operations and decisions, impacting stakeholders and society.

Ecotricity

A concept focused on producing electricity from renewable sources with minimal environmental impact, often associated with green energy initiatives.

Normative

Relating to an ideal standard or model, or based on what is considered to be the proper way of doing something.