Case-Based Critical Thinking Questions Case 1 - MaidToOrder

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