ProductType Is a Foreign Key Field in the Orders Table

question 24

Multiple Choice

ProductType is a foreign key field in the Orders table and is constrained to a list of valid entries stored in the ProductTypes table. What problem does this design prevent?

• A)creation anomalies
• B)deletion anomalies
• C)update anomalies
• D)record locking

---

Definitions:

Technical Trading Strategies

Methods used by traders that rely on technical analysis and market indicators to make buy or sell decisions.

True Trend

The authentic direction in which a market or a stock's price is moving over a specific time period.

Moving Average

A statistical measure that smooths out price data by creating a constantly updated average price over a specific period of time.

Buy Signal(s)

Indications or signals used by investors to suggest the optimal time to purchase a stock or investment.