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
What are diverse clauses that form a part of sql?
Explain difference between control flow and data flow?
What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?
What is instead of dml trigger?
what are the core components of SSRS?
How do I determine how many instances of sql server are installed on a computer?
How to apply cascading referential integrity in place of triggers?
Explain primary key?
What is query processing?
What is database replication? What are the different types of replication you can set up in sql server?
Explain indexed views?
Mention the different authentication modes in sql server.
What happens if you are trying to access a schema not owned by you?
how many layers of tcp/ip protocol combined of? : Sql server database administration
what are the new features introduced in sql server 2000? : Sql server database administration
