Case-Based Critical Thinking Questions Case 1 - MaidToOrder

question 22

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 select all invoices of $200.00 or more and arrange the invoices in ascending order by Customer number?

• A) Dim records = From customer In CustomerDataSet.tblCustomer Where customer.InvoiceAmt > 200 Order By invoice.CustomerNum Select customer
• B) Dim records = From customer In CustomerDataSet.tblCustomer Where customer.InvoiceAmt > 200 Order invoice.CustomerNum Ascending Select customer
• C) Dim records = From CustomerDataSet.tblCustomer Where customer.InvoiceAmt > 200 Order invoice.CustomerNum Select customer
• D) Dim records = From customer In CustomerDataSet.tblCustomer Where customer.InvoiceAmt Order By invoice.CustomerNum Select customer

---

Definitions:

Interest Income

Earnings received from deposit accounts like savings or money market accounts, certificates of deposit, or income from bonds and loans made to others, calculated as a percentage of the principal amount.

Laissez-Faire

An economic philosophy of free-market capitalism that opposes government intervention.

Socialist

A person who advocates for or supports the political and economic theory of socialism, which emphasizes public or community ownership and administration of the means of production and distribution of goods.

Utopian

Relating to an imagined perfect society where everything is ideal, often used to describe unrealistic or idealized concepts for societal organization.