Martine's Database Administrator Has Set Up a View for Her

question 30

Multiple Choice

Martine's database administrator has set up a view for her so that she can access the information she needs from the database. What will happen when new columns Martine does not need to see are added to the base tables used for Martine's view?

• A) The new columns will appear in Martine's view.
• B) The data independence provided by the view will be lost.
• C) The administrator will have to change the view's defining query.
• D) Martine can continue to use her view as usual.

---

Definitions:

Profit-Volume Chart

A chart plotting only the difference between total sales and total costs for various levels of units sold.

Break-Even Point

The point at which total costs and total revenues are equal, meaning a business neither makes a profit nor suffers a loss.

Unit Selling Price

The selling rate per unit of a product to consumers.

Enterprise Product

A product designed specifically for organizational or business use, typically addressing complex needs and facilitating enterprise operations.