While creating a view from two tables, you need to ensure that view cannot be affected by modifications to underlying table schema. What should you do to accomplish this goal with least possible amount of overhead?
Create CHECK constraints on the tables
Create a DDL trigger to rollback any changes to the tables if then changes affect the columns in the view.
Create the view, specifying the WITH SCHEMABINDING option.
Create the view, specifying the WITH CHECK option.