What Type of Query Should You Create If You Want

question 6

Multiple Choice

What type of query should you create if you want to change a manager's name from "Jones" to "Ames" for all selected records?

• A) Update
• B) Select with self join
• C) Is Null
• D) Append

---

Definitions:

Risk Premium

The risk premium is the extra return above the risk-free rate that investors demand as compensation for the risk of investing in a particular asset.

Portfolio Beta

A measure of the volatility, or systematic risk, of a portfolio of assets in comparison to the market as a whole.

Unsystematic Risk

Risk associated with a specific company or industry, which can be mitigated through diversification.

Market Risk

The possibility of an investor experiencing losses due to factors that affect the overall performance of the financial markets.