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 join and right join?
Is there a 64 bit version of ssms?
Is left join same as join?
Mention what plvcmt and plvrb does in pl/sql?
what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba
what is a database transaction? : Sql dba
What is the difference between sql and t sql?
How you improve the performance of sql*loader? : aql loader
How can use stored procedures in sql?
What is sql not null constraint?
what happens when the column is set to auto increment and you reach the maximum value for that table? : Sql dba
how to convert dates to character strings? : Sql dba
If a cursor is open, how can we find in a pl/sql block?
How to prepare for oracle pl sql certification?
What is dynamic query?
