Answer Posted / neetu
a view is a virtual table.it's an object that derives it's
data from one or more tables.it ensures that users are able
to retrieve and modify only the data which is seem by them.
u r unable to update attributes becoz views allow only one
of the underlying tables to be updated at a time.u need to
update attributes by giving two separate update commands.
Is This Answer Correct ? | 24 Yes | 8 No |
Post New Answer View All Answers
What is an entity-relationship diagram (erd)?
What does REVERT do in SQL Server 2005?
what's the difference between a primary key and a unique key? : Sql server database administration
Does sql server 2000 clustering support load balancing?
What is log ldf?
Can a table be moved to different filegroup?
What is attribute? : sql server analysis services, ssas
What is the use of attributehierarchyvisible ? : sql server analysis services, ssas
What is join query?
Do you know what are the differences between lost updates and uncommitted dependencies?
How to write character string constants or literals in ms sql server?
What is clustered vs nonclustered index?
How to select some specific rows from a table in ms sql server?
Explain try...catch with sql server?
what is the difference between a primary key and a unique key? : Sql server database administration