What is a view? Why use it?
A view is a virtual table made up of data from base tables and other views, but not stored separately.
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 Siebel Admin Mode View? How to Create this? 03.11.08
Admin Mode property set to TRUE in View object definition. Admin Mode view overrides the property of Business component. This view allow the user to do u...How do you specify a view to be displayed as aggregate view in Siebel 7.7 03.11.08
when adding view to screen specify the type as aggregate view.But Before that you should create the parent category.then add this parent category to aggrega...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...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...Can a view be updated/inserted/deleted? If Yes - under what conditions? 16.05.08
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 n...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 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...