Interested to Buy Any Domain ? << Click Here >> for more details...
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 where clause and having clause? : Sql dba
What is a database trigger?
What are the syntax and use of the coalesce function?
What is not in sql?
Is microsoft sql free?
How many clustered indexes can be created on a table?
How does postgresql compare to oracle/db2/ms sql server/informix?
What steps server process has to take to execute an update statement?
Does inner join return duplicate rows?
how to create a new table by selecting rows from another table in mysql? : Sql dba
What is pl sql record in oracle?
What is a left join?
Can you rollback after commit?
What is dbo in sql?
give the syntax of grant and revoke commands? : Sql dba
