Answer Posted / ram
hold on..
all above are correct
incase of simple view dml operations are allowed
(simple view mean view creates based on one table)
incase of complex view dml operrations not allowd
(complex view create based on more than 1 table)
one more thing is in oracle
materialized view maintain physical copy of data
(dml operations on base tables not reflect on materialized view)
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Are there any features that are decommissioned in 11g that are not present in 11g?
What is mdf ldf and ndf?
Are stored procedures compiled?
What is natural join in sql?
Define a temp table?
How do I use google cloud in sql?
What operating systems are supported by oracle sql developer?
How do you explain an index number?
Can we call dml statement in function?
How to fetch values from testtable1 that are not in testtable2 without using not keyword?
What is sqlcontext?
what is a join? : Sql dba
what are myisam tables? : Sql dba
What is trigger in pl sql?
What is a scalar value in sql?
