Interested to Buy Any Domain ? << Click Here >> for more details...
Explain different types of Views ?
- 5 Answers
- 36401 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 |
what is the difference between two and three-tier architectures?
What is procedure in database?
What is information schema in database?
What is the best free database software?
What is atomicity in dbms?
Which of the packaged procedure is UNRESTRICTED ?
Explain by listing some of dbms major advantages.
dear all,Greetings of the day.. i have a small query plz rply if u knw.. i have done MBA Hr and B.sc microbiology. i am very much interested in it industry,so i am planing to go with oracle HRMS module,can it be work out??
What is the best database software?
What is the rdbms concept in sql?
what is the index and synonym. i have the definitions ...can any one give me brief explanation.. with regards,
What are the main components of a database in healthcare?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
