Interested to Buy Any Domain ? << Click Here >> for more details...
Explain different types of Views ?
- 5 Answers
- 36385 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
Define entity, entity type, and entity set.
Is sql a database?
Explain the classification of Database Management System?
What is a clause in terms of sql?
State at least four kinds of indexing?
What do you know about Master Data & Transaction Info Package?
What are the features of rdbms?
What is unique key in dbms?
Define the relationship between ‘view’ and ‘data independence’.
What is an extensible database?
How do you open .db files?
Explain atomicity and aggregation?
What is cold backup (in case of oracle)?
How to write udf s in delphi?
Define ddl and dml.
