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
Can a primary key be a foreign key?
What are the various restrictions imposed on view in terms of dml?
Can you join views in sql?
What is sql stand for?
Explain constraints in sql?
What is rank () in sql?
How do you update a table in sql?
how to show all tables with 'mysql'? : Sql dba
Are pl sql variables case sensitive?
Does sql*plus also have a pl/sql engine?
differentiate between float and double. : Sql dba
What is rtm stands for?
What is a .db file?
What is meant by user defined function?
How can a pl sql block be executed?