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
You might also like to view...
A(n) ________ uses computer networks and communications technology to bring people together to work on projects.
A) virtual enterprise B) open system C) enterprise system D) official subculture
When you resize an object by the square sizing handles, you adjust the width and height simultaneously
Indicate whether the statement is true or false
The SNMP management system is a computer running management software.
Answer the following statement true (T) or false (F)
When you upload your video to Blogger, Blogger will convert it into two different formats: an MP4 version for the podcast feed and a(n) ____ to display in the show notes blog post.
A. Adobe version B. JavaScript version C. Flash version D. Java version