Question

which query allows addition deletion updating and appending operations on data​

Answer 1

Answer:

If the view contains joins between multiple tables, you can only insert and update one table in the view, and you can't delete rows. You can't directly modify data in views based on union queries. You can't modify data in views that use GROUP BY or DISTINCT statements.

Answer 2

Answer:

action query may be its right