Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / rhys
A view is a "virtual" (isn't physically stored) table. It hides complex details (you can join multiple tables together), provides security/privacy (users can set which columns are available for different people) and it allows read-only access.
The view data dictionary will be updated along side the master data dictionary. For example, if I updated a client's name in the master table, the view would also be amended.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
As per your opinion what are the five top responsibilities of a dba? : sql server database administration
How to use “drop” keyword in sql server and give an example?
What is checkpoint process in the sql server?
what is hash nonclustered index
What are the dmvs?
What is role playing dimension with two examples? : sql server analysis services, ssas
What is the command used to check locks in microsoft sql server?
How to list all schemas in a database?
What is the difference between for auto and for nested?
Is it safe to delete log files?
Explain different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?
What are the different types of replication you can set up in sql server?
What is meant by dirty read?
How to make a column nullable?
How to find which stored procedure is currently running in sql server?
