Answer Posted / kalyana chakravarthy
View is a taliored representation of data of a particular
table. In one way to say view is a shadow of a table. What
ever U do on a view will reflect on the table vice versa.
Views r 2 types simple and complex simple is selected rows
from one table and complex is selected from more than one.
In oracle complex view can be updated by using instead of
triggers from version 8.0
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
Explain the phases a transaction has to undergo?
Can we add an identity column to decimal datatype?
How do you know if sql server is running on your local system?
What is hierarchy, what are its types and difference between them? : sql server analysis services, ssas
What new changes are being made in SQL Server?
What happens when the SQL Azure database reaches Max Size?
What happens when unicode strings concatenate with non-unicode strings?
How can we check the sql server version?
How do I uninstall sql server 2014?
Which Model uses the SET concept
What are window functions in sql server?
Why I have to use stored procedures?
Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?
How can we improve performance by using SQL Server profiler?
What is an expensive query?