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
How to rebuild the master database?
Please explain go command in sql server?
What is it’s similarity with sql server?
How can we rewrite sub-queries into simple select statements or with joins?
What is triggers in ms sql server?
What are the hotfixes and patches in sql server?
Is it possible to call a stored procedure within a stored procedure?
Difference Between ORDER BY Clause and GROUP BY Clause in SQL?
What is open database communication (odbc)?
Can we write a distributed query and get some data which is located on other server and oracle database?
Explain following error properties?
What is the Difference Between Primary and Foreign Key?
how to do partition in sqlserver
What function does a database engine serve in the sql server?
What is best institute to Learn DotNET And SQL in chennai?
