GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Interview Questions  >  Oracle  >  Concepts and Architecture
Go To First  |  Previous Question  |  Next Question 
 Concepts and Architecture  |  Question 11 of 74    Print  

What is a View ?

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 uses.)




  
Total Answers and Comments: 8 Last Update: October 17, 2007   
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
October 13, 2005 15:46:45   #1  
sandeep vig        

RE: What is a View ?
a view is a just like a window so to acces specified data from a base table.a user can not access directly the table thus a view provides additional security.in addition a user don t have to write comlex queries on his end.
 
Is this answer useful? Yes | No
December 27, 2005 15:31:05   #2  
Sangeeta        

RE: What is a View ?
View is simply a JSP file.No flow logic no business logic no model information--just tags.
 
Is this answer useful? Yes | No
January 31, 2006 17:15:43   #3  
KIRAN BANDARI        

RE: What is a View ?
A view is a logical entity. It is a SQL statement stored in the database in the system tablespace. Data for a view is built in a table created by the database engine in the TEMP tablespace
 
Is this answer useful? Yes | No
February 23, 2006 06:06:37   #4  
Raghunath BhairavaJosula        

RE: What is a View ?
A View is nothing but the presentation part to the client application with in a browser environment.It Will contain Both Static as well as Dynamic Content
 
Is this answer useful? Yes | No
April 17, 2006 15:17:01   #5  
sridharreddym        

RE: What is a View ?

Hi sangeetha

thanks for giving the info.

please send me oracle apps faqs.

Thanks and regards

sridhar reddy.


 
Is this answer useful? Yes | No
October 24, 2006 09:48:01   #6  
thumatinagaraju Member Since: October 2006   Contribution: 26    

RE: What is a View ?
View is also a data base object which represent the subset of data from one or more tables.. when u select a view it internally refers the table on which it's created when u drop a table the index on that table will be dropped but the view can't dropped .......but if u want to drop view u can drop itdrop view ..;ok friends byeee
 
Is this answer useful? Yes | No
July 31, 2007 23:04:21   #7  
Mohamed Khaliqh        

RE: What is a View ?

Hi kiran

Views stored in the database but it doesnt contain any data. In the runtime only it poputates the data. Also it doesnt have any queries.. it is created thru navigation only.. in program we have to use it as tables...

bye



 
Is this answer useful? Yes | No
October 17, 2007 10:35:28   #8  
C.Ramesh        

RE: What is a View ?
View is a Virtual Table. It likes like a table. View provide additional level tabel security and providing selected columns only and it accessing different tables no need to joins of different tables. Views also stores data like (Materialized Views) it can be referesh methods like fast complete.
 
Is this answer useful? Yes | No


 
Go To Top


 Sponsored Links

 
About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape