| |
GeekInterview.com > Interview Questions > Mainframe > DB2
| Print | |
Question: What is a view? Why use it?
Answer: A view is a virtual table made up of data from base tables and other views, but not stored separately. |
| November 11, 2006 05:49:21 |
#3 |
| chandra kanth ganga |
Member Since: Visitor Total Comments: N/A |
RE: What is a view? Why use it? |
View is a vitual table, which do not have physical storage.we can create a view from one or more than one table(s) or view(s).if any modification is done on the base table the view is also get effected.but they are some limitations while creating views while using joins. |
| |
Back To Question | |