More DBA job interview questions and answers at
http://dba.fyicenter.com/Interview-Questions/
(Continued from previous question...)
How can you ensure they do not change the underlying tables without also changing the view and not disrupt their workflow?
You have created a view and are concerned that your developers might change the underlying tables' structure and cause problems in the view. How can you ensure they do not change the underlying tables without also changing the view and not disrupt their workflow?
Answer: Use the SCHEMABINDING option in the CREATE VIEW statement.
Explanation: The best way to ensure this is to use the SCHEMABINDING option when creating the view. This ensures that the underlying tables' schema cannot be changed. The view must be dropped or altered to allow the changes
(Continued on next question...)