The TblItems Table Contains a Numeric Field Named Price

question 6

Multiple Choice

The tblItems table contains a numeric field named Price.Which of the following statements finds the lowest price for an item and assigns the result to the dblLowPrice variable?

• A)Dim dblLowPrice As Double =Min item In Items.DataSet.tblItemsSelect item.Price
• B)Dim dblLowPrice As Double =Aggregate item In Items.DataSet.tblItemsSelect item.Price Into Min()
• C)Dim dblLowPrice As Double =Select Min item In Items.DataSet.tblItems
• D)Dim dblLowPrice As Double =Select Aggregate item In Items.DataSet.tblItemsInto Min()

---

Definitions:

Spelling And Grammar Dialog Box

The Spelling and Grammar Dialog Box is a feature in text editing applications used to check and correct spelling and grammatical errors in a document.

Synonym

A word or phrase that means exactly or nearly the same as another word or phrase in the same language.

Thesaurus

A reference work that lists words grouped together according to similarity of meaning, often used to find synonyms and antonyms.

Find Dialog Box

A feature in many software applications that allows users to search for text or other data within a document or file.