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

What is materialized view in sql?

650


Why are sql stored procedures used?

798


How can get second highest salary in sql?

688


explain the advantages and disadvantages of stored procedure? : Sql dba

709


Is join same as left join?

751






What is pl sql collection?

694


How to convert comma separated string to array in pl/sql?

810


What is percent sign in sql?

922


How are sql commands classified?

799


What is faster join or subquery?

709


When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?

843


What do you think about pl/sql?

701


how to drop an existing view in mysql? : Sql dba

789


Where the sql database files are stored?

692


what is timestamp in mysql? : Sql dba

742