Interested to Buy Any Domain ? << Click Here >> for more details...
Explain different types of Views ?
- 5 Answers
- 36564 Views
- HCL, Inbound Solutions, I also Faced
- E-Mail Answers
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
Operators used in select statements are?
What are dml and ddl statements?
Enlist some commands of ddl?
What are vdl and sdl?
What is database or database management systems (dbms)? And what's the difference between file and database? Can files qualify as a database?
Explain 2nf?
What are the steps in creating a database?
What are the characteristics of dbms?
What is the database approach?
How to specify transaction or query timeout?
Suppose database is running slow, what will you do?
What is the difference between a catalog and a database?
Explain all codd's rules for relational database system?
What is entity and its types?
Differentiate between ‘cluster’ and ‘non-cluster’ index.
