Question: POSTALCODE data type CustID Cust Type City PostalCode SalesOrderNum ProductID OrderQty LineTotal ProductName ProductLine ProductListPrice 6 9 7 S Tooele 8 4 0 7 4

POSTALCODE data type
CustID
Cust Type
City
PostalCode
SalesOrderNum
ProductID
OrderQty
LineTotal
ProductName
ProductLine
ProductListPrice
697
S
Tooele
84074
SO50270
863
44
639.3717
Full-Finger Gloves, L
M
37.99
146
L
Seattle
98104
SO67266
869
41
1097.6182
Women's Mountain Shorts, L
A
69.99
697
S
Tooele
84074
SO51783
867
40
1259.82
Women's Mountain Shorts, S
A
69.99
546
L
Loveland
80537
SO57186
869
40
1259.82
Women's Mountain Shorts, L
A
69.99
546
L
Loveland
80537
SO48089
863
39
666.7245
Full-Finger Gloves, L
M
37.99
146
L
Seattle
98104
SO67266
867
38
1196.829
Women's Mountain Shorts, S
A
69.99
697
S
Tooele
84074
SO51783
869
36
1133.838
Women's Mountain Shorts, L
A
69.99
302
S
Offenbach
63009
SO51109
864
36
1028.7
Classic Vest, S
S
63.5
125
S
Stamford
06901
SO46610
863
35
598.3425
Full-Finger Gloves, L
M
37.99
315
S
Merritt Island
32952
SO46673
863
35
598.3425
Full-Finger Gloves, L
M
37.99
PostalCode is the zip code of shipping address for the order, and is always required for each order. It is always 5 digits.
Which ONE of the following is the most appropriate data type to use for PostalCode ?
char
int
varchar
char(5)
varchar(5)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!