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 recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?
How can you transfer data from a text file to a database table? Or how can you export data from a table to a comma delimited (csv) file? Or how can you import data from ms access to a table in a database? Or how can you export data from a table to an excel file?
What is pessimistic concurrency?
Give me any three differences between Truncate and Delete.
Give me a SQL Query to find out the second largest company?
what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration
What is the purpose of self join?
What is raiseerror? What is raiseerror?
What is similarity and difference between truncate and delete in sql?
When is the use of update_statistics command?
What is the difference between mysql and mysqli?
What keyword you will use to get schema appended to the result set of a ‘for xml’ query?
What are the steps you must follow to hide sql server instances?
What is the partitioning method?
How to create dbo table in sql server?