Question #1 is too complicated for this automatic grading system, so we are omit

Question

Question #1 is too complicated for this automatic grading system, so we are omitting it and re-scaling question #2 to be 20 points.

Examine the following sample database table:

Enter each numeric answer without commas or extra blanks.

A. How many fields are currently in the table
(use both interpretations of "field")?

B. How many records are currently in the table?

C. What are the data types of all fields?

D. What would be the first Part Number value if the table was sorted in ascending order on the Part Number field?

E. What would be the first Part Number value if the table was sorted in ascending order on the Pricefield?

F. What would be the last Part Number value if the table was sorted in descending order on the Number in Stock field?

G. How many records would be in the result if I executed a query where the Number in Stock query box contained the expression >3 ?

Question #1 is too complicated for this automatic grading system, so we are omitting it and re-scaling question #2 to be 20 points.

Examine the following sample database table:

Enter each numeric answer without commas or extra blanks.

A. How many fields are currently in the table
(use both interpretations of "field")?

Sloppy Precise

B. How many records are currently in the table?

C. What are the data types of all fields?

Part Number Identifier Price Number in Stock

D. What would be the first Part Number value if the table was sorted in ascending order on the Part Number field?

E. What would be the first Part Number value if the table was sorted in ascending order on the Pricefield?

F. What would be the last Part Number value if the table was sorted in descending order on the Number in Stock field?

G. How many records would be in the result if I executed a query where the Number in Stock query box contained the expression >3 ?

HIM Part Number 1024 1132 6743 9999 S146 1001 1108 2994 Identifier Multifrequency Field Coils Polymophi: Transdurer Array's Starboard Power Couplings Noncontinuous Injector Points Plasma Containment Shields Phased Array Sensor Modules Artimatter Buffer Interfaces Hamburger with a side of Fries Price Number In Stock $14,774.00 $2,278.34 12 $9.703.33 $479.12 15 $47,067.99 $31,000.78 $76,144.00 $2.37 2358 le

Explanation / Answer

A. How many fields are currently in the table
(use both interpretations of "field")?
sloppy: 4 Fields
Precise: 32

B. How many records are currently in the table?
record in a table is a complete row.
8 records.

C. What are the data types of all fields?
Part Number - Integer
Identifier - varchar
Price - float
Number in Stock - Float

D. What would be the first Part Number value if the table was sorted in ascending order on the Part Number field?
1001

E. What would be the first Part Number value if the table was sorted in ascending order on the Pricefield?
2994

F. What would be the last Part Number value if the table was sorted in descending order on the Number in Stock field?
5146

G. How many records would be in the result if I executed a query where the Number in Stock query box contained the expression >3 ?
4 records.

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

---