DB2 - What is a view? Why use it?

GeekInterview.com > Interview Questions > Mainframe > DB2

Go To First | Previous Question | Next Question

DB2 | Question 10 of 195

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.

Total Answers and Comments: 3

Last Update: November 10, 2006

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

October 04, 2005 13:34:01

Nimesh

RE: What is a view? Why use it?

every time a view is accessed the data in it is refreshed

Is this answer useful? Yes | No

October 24, 2006 14:14:42

vijay saxena

RE: What is a view? Why use it?

a view table is virtual or logical table which depends on base table by using this the filtered records may be accessed frequently.

Is this answer useful? Yes | No

November 10, 2006 05:49:21

chandra kanth ganga

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.

Is this answer useful? Yes | No

Go To Top