Interested to Buy Any Domain ? << Click Here >> for more details...
Explain different types of Views ?
- 5 Answers
- 36562 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 to Handle Missing Data in a Database?
Is driver a software?
What is local database?
What is tabular form?
What are the different types of data tables?
HI THIS IS SHEKAR MY QUTION IS IF I HAD 10 YEARS DATA IN MY SOURCE THEN I WANT TO LOAD ONLY LAST YEAR DATA HOW IT IS POSSIBLE BY USING DATASTAGE7.5.
Explain the terms specialization and generalization.
What is database optimization?
What is the mechanism provided by ORACLE for table replication ?
How can I access my database remotely?
What are the disadvantages of a query?
What is difference between database and dbms?
-
Oracle (3253) - 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)
