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
Do you know what is a linked server in sql server?
Difference Between ORDER BY Clause and GROUP BY Clause in SQL?
Tell me what are the advantages of using stored procedures?
How to generate create view script on an existing view?
Is resultset an interface?
What is BCP? When does it used in sql server 2012?
What are the benefits of normalization?
Can we use where clause with group by?
How many non clustered indexes there can be on table ?
What is a print index?
What do you understand by user-defined function in the sql server?
Explain about nested stored procedure?
How do we Backup SQL Azure Data?
You have several tables, and they are joined together for querying. The tables contain both clustered indexes and non clustered indexes to optimize performance, how should you distribute the tables and their indexes onto different file groups?
What is store procedure? How do they work?
