An auo dealer's tblTrucks table has two text fields named Make and Model, and two numeric fields named Year and ListPrice. In the TableAdapter Configuration Wizard, which of the following statements adds the numbers in the ListPrice field to give a total value for the dealer's truck inventory?
A. SELECT SUM(ListPrice) AS TotalValue
B. SELECT AGGREGATE(ListPrice) FROM tblTrucks
C. SELECT SUM(ListPrice) AS TotalValue FROM tblTrucks
D. SELECT (@ListPrice) FROM tblTrucks
Answer: C
You might also like to view...
_________ combines the formatting strengths of HTML 4.0 and the data structure and extensibility strengths of XML
a. DHTML b. SGML c. HTML 5.0 d. XHTML
Sniffers operate at the network layer of the OSI model
Indicate whether the statement is true or false.
You can click the Distribute Rows Evenly or Distribute Columns Evenly buttons on the Tables toolbar to make all rows and columns the same height or width.
Answer the following statement true (T) or false (F)
The operators that cannot be overloaded are .,.*,::,?:,and ____________________.
Fill in the blank(s) with the appropriate word(s).