ORDERQTY data type CustID Cust Type 697 S City Tooele 146 L Seattle 98104 PostalCode SalesOrderNum 84074 SO50270 SO67266 863 ProductID Order Qty LineTotal 639.3717 ProductName ProductLine ProductListPrice 44 Full-Finger Gloves, L M 37.99 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 302 125 315 SSSS Tooele 84074 SO51783 869 36 1133.838 Women's Mountain Shorts, L A 69.99 S Offenbach 63009 SO51109 864 36 1028.7 Classic Vest, S S 63.5 Stamford 06901 SO46610 863 35 598.3425 Full-Finger Gloves, L M 37.99 Merritt Island 32952 SO46673 863 35 598.3425 Full-Finger Gloves, L M 37.99 OrderQty is always present and is a whole number. It varies between 1 to maximum of 100. Which ONE of the following is the most appropriate data type to use for OrderQty? O decimal(100) O decimal O smallint O int ○ tinyint W 13
ORDERQTY data type CustID Cust Type 697 S City Tooele 146 L Seattle 98104 PostalCode SalesOrderNum 84074 SO50270 SO67266 863 ProductID Order Qty LineTotal 639.3717 ProductName ProductLine ProductListPrice 44 Full-Finger Gloves, L M 37.99 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 302 125 315 SSSS Tooele 84074 SO51783 869 36 1133.838 Women's Mountain Shorts, L A 69.99 S Offenbach 63009 SO51109 864 36 1028.7 Classic Vest, S S 63.5 Stamford 06901 SO46610 863 35 598.3425 Full-Finger Gloves, L M 37.99 Merritt Island 32952 SO46673 863 35 598.3425 Full-Finger Gloves, L M 37.99 OrderQty is always present and is a whole number. It varies between 1 to maximum of 100. Which ONE of the following is the most appropriate data type to use for OrderQty? O decimal(100) O decimal O smallint O int ○ tinyint W 13
Chapter1: Taking Risks And Making Profits Within The Dynamic Business Environment
Section: Chapter Questions
Problem 1CE
Related questions
Question

Transcribed Image Text:ORDERQTY data type
CustID
Cust Type
697
S
City
Tooele
146
L
Seattle
98104
PostalCode SalesOrderNum
84074
SO50270
SO67266
863
ProductID Order Qty LineTotal
639.3717
ProductName
ProductLine
ProductListPrice
44
Full-Finger Gloves, L
M
37.99
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
302
125
315
SSSS
Tooele
84074
SO51783
869
36
1133.838
Women's Mountain Shorts, L
A
69.99
S
Offenbach
63009
SO51109
864
36
1028.7
Classic Vest, S
S
63.5
Stamford
06901
SO46610
863
35
598.3425
Full-Finger Gloves, L
M
37.99
Merritt Island
32952
SO46673
863
35
598.3425
Full-Finger Gloves, L
M
37.99
OrderQty is always present and is a whole number. It varies between 1 to maximum of 100.
Which ONE of the following is the most appropriate data type to use for OrderQty?
O decimal(100)
O decimal
O smallint
O int
○ tinyint
W
13
AI-Generated Solution
Unlock instant AI solutions
Tap the button
to generate a solution
Recommended textbooks for you

Understanding Business
Management
ISBN:
9781259929434
Author:
William Nickels
Publisher:
McGraw-Hill Education

Management (14th Edition)
Management
ISBN:
9780134527604
Author:
Stephen P. Robbins, Mary A. Coulter
Publisher:
PEARSON

Spreadsheet Modeling & Decision Analysis: A Pract…
Management
ISBN:
9781305947412
Author:
Cliff Ragsdale
Publisher:
Cengage Learning

Understanding Business
Management
ISBN:
9781259929434
Author:
William Nickels
Publisher:
McGraw-Hill Education

Management (14th Edition)
Management
ISBN:
9780134527604
Author:
Stephen P. Robbins, Mary A. Coulter
Publisher:
PEARSON

Spreadsheet Modeling & Decision Analysis: A Pract…
Management
ISBN:
9781305947412
Author:
Cliff Ragsdale
Publisher:
Cengage Learning

Management Information Systems: Managing The Digi…
Management
ISBN:
9780135191798
Author:
Kenneth C. Laudon, Jane P. Laudon
Publisher:
PEARSON

Business Essentials (12th Edition) (What's New in…
Management
ISBN:
9780134728391
Author:
Ronald J. Ebert, Ricky W. Griffin
Publisher:
PEARSON

Fundamentals of Management (10th Edition)
Management
ISBN:
9780134237473
Author:
Stephen P. Robbins, Mary A. Coulter, David A. De Cenzo
Publisher:
PEARSON