In Oracle,will a change in view cause a change in the table.?

Answer 1

Yes, provided the user who has authorization for the view also has authorization to run updates on the underlying table.

You can explicitly prevent that by using the WITH READ ONLY predicate:

CREATE OR REPLACE VIEW myView AS
SELECT * FROM table;
WITH READ ONLY;

Answer 2

Yes changing in view will affect the underlying tables on which view is based. The owner of the schema containing the view must have the privileges necessary to insert, update, or delete rows from all the tables or views on which the view is based. The owner must be granted these privileges directly, rather than through a role.

Answer 3

Yes. But the rules for updatable views can get complicated. Views can also be created to be read only. "Instead of triggers" can be used to make complex views updatable.

Answer 4

yes view is the imaginarary table of the real table