Answer Posted / satish asnani
Answer from Santosh Kumar is correct with slight
improvement. The simple views are actually called Updateable
Views and Complex views are called Non-Updateable Views.
Updateable means we can perform DML operations(Insert,
Update & Delete) on such views. Non-Updateable means we
cannot perform DML operations.
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
Which one is better subquery or joins?
What is a temp table?
How do I create a sql script?
how to rename an existing table in mysql? : Sql dba
How do I trace sql profiler?
What is procedure explain with program?
What is dcl in sql?
How do I remove all records from a table?
what are the disadvantages of mysql? : Sql dba
Does oracle roll back the transaction on an error?
Define join and name different types of joins?
Lookups are a key component in sql server integration services (ssis). Explain its purpose?
What is a unique key?
Define a temp table?
What is the difference between rename and alias?