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
Which are the two editions in which SQL Azure database available?
Can we call future method from trigger?
How does recursive cte works in sql server?
What is 'write-ahead log' in sql server 2000 ?
What is NOT NULL Constraint in sql server 2012?
Explain the difference between clustered and non-clustered index?
What are the properties of the relational tables?
how can you attach more than 20 ldf files in sql server
How you trouble shoot when any job fails
What is sql server english query?
Why would you use sql agent?
Explain indexing and what are the advantages of it?
What are examples of triggers?
What is normalization? What number of normalization shapes are there?
What is a transact-sql statement?