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  >  Database

 Print  |  
Question:  What is view? Types of views?use of views?how to create view(syntax)?



March 03, 2006 12:04:27 #3
 sreyaskvmce&it   Member Since: March 2006    Total Comments: 6 

RE: what is view?types of views?use of views?how to cr...
 

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 base table. In other words, there is no stored file that direct represents the view instead a definition of view is stored in data dictionary.
Growth and restructuring of base tables is not reflected in views. Thus the view can insulate users from the effects of restructuring and growth in the database. Hence accounts for logical data independence.

There are two type of views:

1,simple view

2,complex view

     

 

Back To Question