Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

Answers were Sorted based on User's Feedback



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

Answer / ehsraka

Yes, definitely. Since the view is based on a single table
and falls within the cateogory of simple view. Any change /
modification on the records will be reflected in the base
table.

Is This Answer Correct ?    8 Yes 0 No

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

Answer / tulsi

yes it will be reflected in the base table

Is This Answer Correct ?    7 Yes 3 No

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

Answer / aks

Depends on privileges granted to view (select,insert,update);

Is This Answer Correct ?    4 Yes 1 No

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

Answer / naresh

Hi

Not only on a single based table, changes made on a view
which created on multiple tables also will update on base
tables,if the relation ship between primary key and Foreign
key relationships are proper and if the Integrity
constraints are mentioned.

Cheers!
Naresh

Is This Answer Correct ?    4 Yes 1 No

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

Answer / papal

yes if there is no use of "CHECK WITH option"
then definitally chnages in view affects the base table

Is This Answer Correct ?    3 Yes 1 No

Post New Answer



More SQL PLSQL Interview Questions

Can a procedure in a package be overloaded?

0 Answers   EXL,


Is full outer join same as cross join?

0 Answers  


I have following column in the table. col1 1 a b c 2 3 d and I want to display it as num chars 1 a 2 b 3 c 4 d numbers in one column and letters in another column.

1 Answers   IBM, Saama Tech,


Difference between inline query and stored procedure?

4 Answers   Bharat, Microsoft,


What is the difference between the Primary and Foreign key?

7 Answers   Cap Gemini,






how u can find the n row from a table?

19 Answers   Tech Mahindra,


How many levels can subqueries be nested in a FROM clause?

7 Answers  


tell us something about heap tables. : Sql dba

0 Answers  


What is a left join?

0 Answers  


How many types of functions are there in sql?

0 Answers  


What are the two characteristics of a primary key?

0 Answers  


What are the properties of a transaction?

0 Answers  






Categories