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 the difference RDBMS and Graph Database?
State the difference between union and union all?
Is mysql the same as sql server?
What are approximate numeric data types in ms sql server?
How to insert stored procedure result into temporary table?
How can change procedure in sql server?
What are different types of database indexes?
What do you mean by data manipulation language?
What is dbcc command in sql server?
Which tcl commands are available on the sql server?
What is normalization? Describe its different types.
What is the Control Flow in SSIS
what do you understand by change data capture?
Explain the advantages of merge replication?
How to modify existing triggers using "alter trigger"?