Explain different types of Views ?
Answer Posted / 9742108000(venu gopal reddy)
The views are Mainly 2 types .
1-> SIMPLE VIEW
2-> COMPLEX VIEW
Simple view:
- It is created by selecting only one table.
- It does not contains functions.
- it can perform DML (SELECT,INSERT,UPDATE,DELETE,MERGE, CALL,LOCK TABLE) operations through simple view.
Complex view :
-It is created by selecting more than one table.
-It can performs functions.
-You can not perform always DML operations through Complex views.
| Is This Answer Correct ? | 22 Yes | 2 No |
Post New Answer View All Answers
What are the types of database?
What are the characteristics of database?
What database should I learn first?
What is the main purpose of a database?
When connection to database is failed, Which exception will be thrown?
What are the package used in DBMS ?
How view is related to data independence?
What are the two types of indexes and explain them in detail?
What do you mean by checkpoints in dbms?
Explain the difference between primary and foreign key?
What is the structure of a database?
What is 3nf in the dbms?
What are the features of database language?
Define identity and uniqueidentifier property of column?
What is database normalization? Explain types of it.