Case-Based Critical Thinking Questions

?
Case 1: MaidToOrderThe 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.
InvoiceNum
CustomerNum
InvoiceDate
InvoiceAmt
InvoicePaid
631
13020
01/15/2013
200.00
Y
632
15411
01/20/2013
685.00
Y
633
10002
01/23/2013
75.00
N
634
13104
01/23/2013
150.00
N
635
12124
01/26/2013
75.00
Y
636
13328
02/02/2013
350.00
Y
637
10206
02/02/2013
175.00
N
638
10334
02/07/2013
450.00
Y
Given the data in the table, which data type would you use for the InvoiceAmt field?

A. char (3, 2)
B. char (5, 2)
C. decimal (3, 2)
D. decimal(5, 2)

Answer: D