If Users Access Only Certain Fields in a Table, How

question 19

Multiple Choice

If users access only certain fields in a table, how can you improve performance?

• A) by splitting the table into two or more tables and removing the primary key
• B) by combining the table with another table that performs better
• C) by splitting the table into two or more tables that each has the same primary key as the original
• D) by adding indexes to each column and deleting the primary and alternate keys

---

Definitions:

Profit-maximizing

A strategy or point where a firm reaches its highest possible profit under given market conditions, taking into account costs and revenue.

Loss

A situation in which a business's expenses exceed its revenues over a specific period, resulting in negative profit.

Price Discrimination

A pricing strategy where a company charges different prices for the same product or service in different markets or to different segments of consumers, based on willingness to pay.

Product Differentiation

The method of differentiating a product or service from those available in the market to enhance its appeal to a specific target audience.