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 query optimizer in sql server?
Where can you find the error log information? : sql server database administration
Explain about nested stored procedure?
When should you use an instead of trigger?
How to rebuild the master database?
What is the log shipping?
What are the source of constraints?
Differentiate between truncate vs delete in mssql?
What does man by sql wildcard characters in sql server?
what are user defined datatypes and when you should go for them? : Sql server database administration
Is sql server implemented as a service or an application? : Sql server database administration
Explain the steps to create and execute a user-defined function in the sql server?
You want to generate a report that is formatted as a chart. Can you use the report wizard to create such a report?
What is dbcc command in sql server?
can you instantiate a com object by using t-sql? : Sql server database administration