Explain different types of Views ?
Answer Posted / sweta
There are two types of view-
1.Simple view(does not contain function, only one table exists,allow DML operation)
2.Complex View (Allow function,multiple table,did not allow DML operations all time)
Attributes of view --
1.with check option
2.read only
3.Force|Noforce
| Is This Answer Correct ? | 6 Yes | 4 No |
Post New Answer View All Answers
What do you understand by ‘database’?
Who is communication horizons?
What is 1nf 2nf 3nf in dbms?
Which parameters are optional in init.ora parameter file?
What is the best database software?
What is use of foreign key?
What is the main difference between union and union all?
Explain the difference between primary and foreign key?
Define database lock?
What do you mean by query evaluation engine?
What is difference between database and website?
What do you mean by durability in dbms?
What is the difference between case version and decode version?
What is key dbms?
What is the role of database management system?