Interested to Buy Any Domain ? << Click Here >> for more details...
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
Why normalization is used?
What are the Advantages of using CTE in sql server?
List out some of the requirements to set up a sql server failover cluster?
What do you mean by an execution plan? How would you view it?
What happens if the update subquery returns no rows in ms sql server?
let's assume you have data that resides on sql server 6.5. You have to move it sql server 7.0. How are you going to do it? : Sql server database administration
How to concatenate two character strings together?
Explain features and concepts of analysis services?
Explain a join?
What are the requirements to use odbc connections in php scripts?
Difference Between ORDER BY Clause and GROUP BY Clause in SQL?
how do you test proper tcp/ip configuration windows machine? : Sql server database administration
Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?
Mention the differences between local and global temporary tables.
Do you know what is rank function?
