Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / sandhya
You can modify data by using a view in only one of its base
tables even though a view may be derived from multiple
underlying tables. For example, a view vwNew that is
derived from two tables, table and table2, can be used to
modify either table or table2 in a single statement. A
single data modification statement that affected both the
underlying tables is not permitted
| Is This Answer Correct ? | 9 Yes | 1 No |
Post New Answer View All Answers
What is RMS migrations?
You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?
What are sparse columns?
Explain transaction isolation levels in sql server?
what type of index will get created after executing the above statement? : Sql server database administration
How to find out what is the default collation in a database?
What are the advantages dts has over bcp?
Explain the purpose of indexes?
After removing a table from database, what other related objects have to be dropped explicitly?
What do you understand by intent locks?
Explain different types of locks in sql server.
What is an identity column in insert statements?
what are the critical issues you have resloved in your company
Describe in brief databases and sql server databases architecture.
Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?
