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
What is the difference between left outer join and left join?
How to check if a column is nullable before setting to nullable?
What is a unique key?
What is the difference between inner join and natural join?
What is cascade in sql?
Can you select everything, but 1 or 2 fields, without writer's cramp?
Do stored procedures prevent sql injection?
which operator is used in query for pattern matching? : Sql dba
What is indexing oracle sql?
What is attribute indicator in pl sql?
What are transaction and its controls?
how mysql optimizes distinct? : Sql dba
What is sql and also describe types of sql statements?
Can one improve the performance of sql*loader? : aql loader
What is a pdo connection?
