DBA > Job Interview Questions > DB2 ( IBM Database 2 ) Interview Questions

Are view updatable?

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

(Continued from previous question...)

Are view updatable?

Not all of them. Some views are updatable e.g. single table view with all the fields or mandatory fields. Examples of non-updatable 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