SQL (Structured Query Language) Question:

Download Job Interview Questions and Answers PDF

If a view on a single base table is manipulated will the changes be reflected on the base table?

SQL Interview Question
SQL Interview Question

Answer:

Changes on the view will be reflected on the base table under certain conditions.

But if changes are made to the tables and these tables are the base tables of a view, then the changes will be reference on the view.

Download SQL Interview Questions And Answers PDF

Previous QuestionNext Question
What are the advantages of VIEW?Which of the following is not a feature of a cursor FOR loop?