1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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

Question Posted / guest

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

What is a stored procedure ?

9 Answers  

What does subquery mean in sql?

1 Answers  

Can a varchar be a primary key?

1 Answers  

How do you retrieve set of records from database server. {Set max records = 100 & use paging where pager page no or records = 10 & after displaying 100 records again connect to database retrieve next 100 }

2 Answers   DELL,

can i create trigger on synonym is it possible or not please help me

4 Answers   CGI,

Does pl sql work in mysql?

1 Answers  

using subquery how can i calculate working days in a month?

3 Answers   Spice Telecom,

What is ttitle and btitle?

1 Answers  

What is materialized view in sql?

1 Answers  

How are functions and procedures called in PL/SQL?

1 Answers  

what is the difference between blob and text? : Sql dba

1 Answers  

What is the current version of postgresql?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories