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
What are the steps you can take to avoid “deadlocks”?
Explain about system database?
Can we perform backup restore operation on tempdb?
What is oltp (online transaction processing)?
What are the two modes of authentication in sql server?
What is self join in sql server joins?
How can I add Reporting Services reports to my application?
How to retrieve error messages using odbc_errormsg()?
What is a derived table?
What is inline table-value user-defined function?
Explain the functionalities that views support?
Explain what is “asynchronous” communication in sql server service broker?
How many tables can be joined in SQL Server?
Explain index in sql server?
What are the five major components of a dbms?