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
Which data type would you use for the InvoicePaid field?
A. char(1)
B. varchar(10)
C. char(A-F)
D. varchar(A-F)
Answer: A
Computer Science & Information Technology
You might also like to view...
What is the difference between Java and Javascript? Be precise.
What will be an ideal response?
Computer Science & Information Technology
When you work in Design view of a crosstab query, you have more control over your query design, which enables features to be added that are not available in the wizard
Indicate whether the statement is true or false
Computer Science & Information Technology
Therapy that involves the use of internet is called ______________.
A. internet counseling B. web counseling C. e-counseling D. on-line counseling
Computer Science & Information Technology
To remove all annotations from a slide, click Pointer Options on the shortcut menu, then click ____.
A. Eraser B. Erase All Ink on Slide C. Arrow Options D. Ink Color
Computer Science & Information Technology