1.

What are views? When can a view be updated?

Answer»

A view is, in essence, a virtual table. It does not physically exist. Rather, it is created by a query joining one or more tables.

In following condition a view can be updated : 

If it has only one base table.

If select statement used in view contains group by clause then we cant update view. 



Discussion

No Comment Found

Related InterviewSolutions