More DBA job interview questions and answers at
http://dba.fyicenter.com/Interview-Questions/
(Continued from previous question...)
122. What is a VIEW? How to get script for a view?
Answer1
View is a logical perspective of a Table. It is a predefined set of query on a table through which we can perform any kind of select queries instead of redefining the condition every time. Update or Insert Statements cannot be performed through this.
Answer2
Update or Insert statements cannot be performed ON View.
Answer3
Update or Insert statements cannot be performed ON View is not correct.
As I know, if a view meets certain criteria you can update it and such operation will be reflected in the original table. Also, if you are using materialized view, you can insert or update it.
(Continued on next question...)
