Explain different types of Views ?
- 5 Answers
- 34012 Views
- HCL, Inbound Solutions, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / vivekanand
basically there are five type of view
1-simple view
2-complex view
3-read only view
4-check option view
5-force view
| Is This Answer Correct ? | 16 Yes | 11 No |
Answer / sweta
There are two types of view-
1.Simple view(does not contain function, only one table exists,allow DML operation)
2.Complex View (Allow function,multiple table,did not allow DML operations all time)
Attributes of view --
1.with check option
2.read only
3.Force|Noforce
| Is This Answer Correct ? | 6 Yes | 4 No |
Answer / kishan j vasoya
There are two types of view.
1. Read only view:
which is created by using more then one table.
2. Updatable view:
Which is created by using one table so it's updatable.
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / aarthigha
data abstraction
data models
instance and schemas
definition languages
| Is This Answer Correct ? | 12 Yes | 20 No |
How do I check my drivers?
What are rdbms concepts?
What is database connection pool size?
What do you know about DBMS?
Define RDBMS.
0 Answers Ernst Young, Thomson Reuters,
What is structure of dbms?
Excellent job opening with one of our client in Hyderabad About Client : It is an American e-commerce company based in Seattle, Washington, a leading online retailer of products that inform, educate, entertain and inspire.
How to schedule ssas database backup
Is a server a database?
What is join? Mention its types.
What is actional flow mapping?
what the SUBSTR(SQUARE ANS ALWAYS WORK HARD,14,6) will return ?
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
