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
Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.
What is dense_rank?
What is bind variable in pl sql?
What does the sign mean in sql?
What are triggers and its types?
How do I view output in sql developer?
How do I count rows in sql query?
What is the difference between rename and alias?
Explain the purpose of %type and %rowtype data types?
Are sql connections encrypted?
What does where 1/2 mean in sql?
Can we write ddl statements in functions?
If the application is running very slow? At what points you need to go about the database in order to improve the performance?
What is the difference between alter trigger and drop trigger statements?
What are the advantages of normalization?
