Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between table and view
- 1 Answers
- 3274 Views
- I also Faced
- E-Mail Answers
Answer / ashok
1.If we create a table it will save in database but a view is a virtual image there is no physical existance.
2. We can use order by clause in tables but views does not support order by clause.
3.In a view we can specify only a select statement inside a view but in tables we use all dml,ddl statements.
4.If we updating a base table using view which contains joins may not update correctly,but in tables we can update using joins.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is cte (common table expression)?
OPTIMIZATION OF SP,CURSOR,TRIGGERS
Explain the advantages of merge replication?
What are the benefits of filtered indexes?
What is INTVAL( )and where we use Plz any body help me
How to turn off warning messages during php execution?
Difference between Inner vs outer joins?
How will you decide the active and passive nodes?
Different types of keys in SQL?
how to improve the speed of SQL database server and how to avoid dead lock?
What is lock escalation? : sql server database administration
What do you know about normalization and de- normalization?
-
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)
