DBA > Job Interview Questions > DB2 INTERVIEW QUESTIONS

Are views updateable ?

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

Are views updateable ?

Not all of them. Some views are updateable e.g. single table view with all the fields or mandatory fields. Examples of non-updateable views are views which are joins, views that contain aggregate functions(such as MIN), and views that have GROUP BY clause.

(Continued on next question...)

Other Job Interview Questions