Views are automatically updated when base tables are updated

Options
- True
- False


CORRECT ANSWER : True

Discussion Board
VIEW

In SQL Server a standard view is nothing but a query. As the underlying data changes, when that query gets accessed, it reflects the changes to the data. It''s automatic, but not because some additional action is occurring to refresh the data in the view.

ABHIJIT 08-10-2017 02:41 PM

Views

Views are not automatically gets updated when base tables are changed, but when a query references a view then a stored query on the view is executed which builds the table on the fly and the updated records are shown.

Ajay M V 09-9-2013 02:33 AM

Write your comments


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)


Advertisement