SQL (Structured Query Language) Question:

Can a view be updated/inserted/deleted? If Yes - under what conditions?

Answer:

A View can be updated/deleted/inserted if it has only one base table if the view is based on columns from one or more tables then insert, update and delete is not possible.

Download SQL PDF Read All 172 SQL Questions

Previous Question	Next Question
How to access the current value and next value from a sequence? Is it possible to access the current value in a session before accessing next value?	Which of the following statements is true about implicit cursors?