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

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

Why stored procedures are faster than query?

568


What is the difference between inner join and outer join?

529


What is sqlerrm?

545


Where not exists in sql?

503


write an sql query to get third maximum salary of an employee from a table named employee_table. : Sql dba

539






hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews

1525


Why left join is used in sql?

516


Is it possible to pass parameters to triggers?

573


how to get a list of columns in an existing table? : Sql dba

540


What does varchar include?

519


What are operators available in sql?

587


Does truncate require commit?

542


why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba

556


Difference between global and parameter variables?

1453


Does inner join remove duplicates?

522