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 are commit and rollback in sql?
What is mean by clustered index and non clustered index, give syntax of creation? : sql server database administration
What is the difference between local and global temporary tables?
Tell me what are the essential components of sql server service broker?
What is the use of custom fields in report?
What are out-of-range errors with date and time literals?
What is Sqlpaging in SqlServer 2005 ?
What is a database table?
you have separate development and production systems you want to move a copy of a development database into production to do this, you do a backup on the development system and restore to the production system after a few minutes, you begin getting calls from several customers saying that they are denied access to the system why? : Sql server administration
mention different types of relationships in the dbms?
What is difference between oltp and olap?
What is an entity-relationship diagram (erd)?
Define candidate key, alternate key, and composite key.
What is use of attributehierarchyenabled? : sql server analysis services, ssas
To automatically record the time on which the data was modified in a table, which data type should you choose for the column?
