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
Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.
Explain nested join?
How we can refresh the view?
What are group functions in query statements in ms sql server?
What is an example of a primary key?
What are recommended options to be used while using db mirroring? : sql server database administration
what is the difference between them (ethernet networks and token ring networks)? : Sql server database administration
What are cursors? Explain the different types of cursors Enlist a few disadvantages of cursors.
How is SQL Azure different than SQL server?
Explain user defined views?
how would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?
How many types of cursor type are there?
What according to you is the difference between mysql and sql server performance?
I create a separate index on each column of a table. What are the advantages and disadvantages of this approach? : Sql server database administration
How to return the second 5 rows in ms sql server?
