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
Is the server accepting tcp ip connections on port 5432?
How do databases work?
Describe reporting lifecycle?
What are the two types of data independence?
Explain about the properties of cursors?
What are the advantages of manual database?
What are the 5 databases?
i have all the Oracle Certification material from 1z0-001 to 1Z0-643, if required just drop me a mail to: summi4you@yahoo.co.in
State some commands of ddl in dbms?
What is pdo in database?
What is data abstraction in dbms?
What is foreign key in dbms?
How many types of users in dbms?
what is the difference between two and three-tier architectures?
What is type of end users?