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
Why stored procedures are faster than query?
What is the difference between inner join and outer join?
What is sqlerrm?
Where not exists in sql?
write an sql query to get third maximum salary of an employee from a table named employee_table. : Sql dba
hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews
Why left join is used in sql?
Is it possible to pass parameters to triggers?
how to get a list of columns in an existing table? : Sql dba
What does varchar include?
What are operators available in sql?
Does truncate require commit?
why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba
Difference between global and parameter variables?
Does inner join remove duplicates?