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.

Question

Quizplus · Accepted Answer

Martine can continue to use her view as usual because a view is defined with a specific query that selects certain columns from the base tables. Adding new columns to the base tables does not automatically alter the view's definition or the columns it includes.

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