If Performance Testing Shows That Queries Based on Frequently Accessed

question 39

Multiple Choice

If performance testing shows that queries based on frequently accessed fields are taking a long time to complete, what can the DBA do that might improve performance?

• A) increase the number of columns
• B) delete foreign keys
• C) add indexes
• D) add alternate keys

---

Definitions:

Inventory Turnover

A measure of how quickly a company sells its stock of goods in a period, calculated by dividing the cost of goods sold by the average inventory level.

Equity Multiplier

A financial leverage ratio that measures the portion of a company's assets that are financed by shareholders' equity.

Debt-to-equity Ratio

The ratio that demonstrates the comparative financing from shareholders' equity and debt for a company's assets.

Times Interest Earned Ratio

The Times Interest Earned Ratio measures a company's ability to meet its debt obligations by comparing its income before interest and taxes to its interest expenses.