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:

Customer Cost Analysis

The process of analyzing all costs associated with acquiring and serving customers to determine their profitability.

Time-Driven Activity-Based Costing

A costing method that assigns costs based on the time it takes to complete specific activities.

Customer Cost Analysis

An examination of the costs related to serving a customer or customer group, used to inform pricing strategies and customer relationship management.

Order Fulfillment Department

A sector in a company tasked with handling and distributing orders to clients.