SQL (Structured Query Language) Question:

Download Job Interview Questions and Answers PDF

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

SQL Interview Question
SQL Interview Question

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 Interview Questions And Answers PDF

Previous QuestionNext 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?