Can a view be updated/inserted/deleted? If Yes - under what conditions?
A View can be updated/deleted/inserted if it has only one base table if the view is based on columns from one or more tables then insert, update and delete is not possible.
If you liked this question/asnwer, make sure you
Subscribe to KyaPoocha.com RSS feed!
BOOKMARK THIS : BlinkList | del.icio.us | Digg it | Furl | reddit | StumbleUpon | Yahoo MyWeb |
Related Interview Questions
What is the difference between view and materialized view ? 22.09.08
Normal Views are for Access purpose ie One need to give access the end user to specific data. Materialized Views are to optimize the performance . WHen mater...How do you load the data conditionally by run steps ? 20.09.08
This depends upon how the ETL is done: If we are loading data using Informatica, the workflow jobs can be scheduled using Autosys or any other scheduler, in...What is an Oracle view ? 18.07.08
A view is a virtual table. Every view has a query attached to it. (The query is a SELECT statement that identifies the columns and rows of the table(s) the view...What are the performance benefits for using Indexed views ? 16.07.08
Views in SQL Server 2000 are very similar to those in previous versions with a few major exceptions when using Indexed views. When a clustered index is created...If the base table underlying a view is restructured, eg. attributes are added, does the application code accessing the view need to be redone? 01.04.08
No. The table and its view are created anew, but the programs accessing the view do not need to be changed if the view and attributes accessed remain the same...Once you create a view, where would information about the view be stored ? 12.03.08
When a view is created, system information about the view is stored in SYSIBM.SYSVIEWS....What is view? Different types of view. 06.03.07
View - A view is a virtual table containing fields from one or more tables. A virtual table that does not contain any data, but instead provides an application-...What is the difference between view and materialized view? 04.08.06
View - store the SQL statement in the database and let you use it as a table. Everytime you access the view, the SQL statement executes. Materialized View...What is Local client view? 26.03.06
The local client view specification is only available in EJB 2.0. Unlike the remote client view, the local client view of a bean is location dependent. Local cl...What is a view? How it is related to data independence? 08.03.06
A view may be thought of as a virtual table, that is, a table that does not really exist in its own right but is instead derived from one or more underlying bas...