Explain different types of Views ?
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 |
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
What is the easiest database to learn?
Is dynamodb a document database?
How to retrive a single data from a database
Describe the difference between homogeneous and heterogeneous distributed database.
Differentiate table scan from index scan.
If you need to refresh a website page every time a record is updated in database, how would you do it?
How to retrive a student with height marks,second height and third height from MS access database what wil be the query for this purpuse?
What does <> mean in database?
What are the advantages of database system?
What are different types of data models?
What is a logical backup ?