GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

  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