Which of the Following Is NOT True About Using Aggregate

question 88

Multiple Choice

Which of the following is NOT true about using aggregate functions in a query?

• A) Aggregate functions can be used in queries to perform calculations on selected fields and records.
• B) By default, the query design grid has a place to enter aggregate functions.
• C) One advantage to using aggregate functions in queries, rather than just a total row, is that you can group criteria and then calculate the aggregate functions for a group of records.
• D) Each column or field can calculate only one aggregate function.

---

Definitions:

Standard Deviation

A statistical measure that quantifies the variation or dispersion of a set of data points, often used to assess the volatility of an investment.

Separation Property

The property that portfolio choice can be separated into two independent tasks: (1) determination of the optimal risky portfolio, which is a purely technical problem, and (2) the personal choice of the best mix of the risky portfolio and the risk-free asset.

Risky Portfolio

An investment portfolio that contains assets with a higher degree of risk, potentially leading to higher returns or greater losses.

Complete Portfolio

The entire portfolio, including risky and risk-free assets.