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
Where is data stored in database?
Explain the Surrogate Key in DBMS.
how Data is stored in a file so that Direct Searching can be performed
What does rdbms stand for?
Who has the largest database?
Which dbms is best?
What is the difference between internal and external schema?
What is drivermanager getconnection?
What do you mean by e-r model?
What is a Federated Query ?
What do you understand by ‘database’?
What do you mean by fill factor concept with respect to indexes?
What is blob database?
What is database Configuration assistant ?
How do I create a database in access 2010?