Whether the updations made to the views reflect the
original records in the table

Answers were Sorted based on User's Feedback



Whether the updations made to the views reflect the original records in the table..

Answer / sabareetha

If the view is created with single table. Updating a view
will affect the origival records in the table

Is This Answer Correct ?    12 Yes 2 No

Whether the updations made to the views reflect the original records in the table..

Answer / ravi sharma

in the case if same table (all column) are make a view then
updations reflect the original record in the table.

but mostly make a view to security purpose the , uniques
are constaint column are not use,
then not be reflect .

Is This Answer Correct ?    7 Yes 0 No

Whether the updations made to the views reflect the original records in the table..

Answer / sangita

No

Is This Answer Correct ?    3 Yes 0 No

Whether the updations made to the views reflect the original records in the table..

Answer / anil

yes

Is This Answer Correct ?    4 Yes 3 No

Whether the updations made to the views reflect the original records in the table..

Answer / soorai ganesh

No. Updating View will not affect the table records.

Is This Answer Correct ?    9 Yes 13 No

Post New Answer

More SQL Server Interview Questions

What are the new features in SQL Server 2005?

3 Answers   Emphasis,


How do I find the query plan in sql server?

0 Answers  


What is the difference between deallocate cursor and close cursor?

0 Answers  


Can select statements be used on views in ms sql server?

0 Answers  


What do you mean by sql server agent?

0 Answers  






please bar with my english i having a database called tblhallreservation in which res_date is date field has to select all the fields in table deponding on month either has to display all details for the month jan or feb and so on

1 Answers  


How would you add a section to a table?

0 Answers  


In performance wise distinct is good or group by is good? eg:select name from emp group by name; select distinct name from emp;

5 Answers   Infosys,


What is database isolation in sql server? : sql server database administration

0 Answers  


What is Sqlpaging in SqlServer 2005 ?

0 Answers   MCN Solutions,


Do you know what are the properties of the relational tables?

0 Answers  


Why I can not enter 0.001 second in date and time literals in ms sql server?

0 Answers  


Categories