what is view? types of views?

Answer Posted / arangaraj

A view is a tailored presentation of the data.contained in
one or more tables or other view.it takes the o/p of a
query and treat it as a table. it does n't require any
space in database.

ex.create view emp1 as select empno,empname from emp;

types of view:Materialised view.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between low affinity and high affinity connections?

759


What are all the types of indexes in Cognos?

881


Define dimensions?

794


It is possible to test 2 query subjects at a time in CRN1.1 & C8 FWM?

2130


write a query to display the departments with no employee?

1732






how you provide security to reports? How you provide security to packages ?

842


How to deploy from one server to another server?

2200


how to perform back drill through in cognos 8 what is the use of it

2234


what are the migration tools available in the market with respect to cognos such as impromptu reports are migrated to cognos reportnet?

763


9. What was the most complex type of report you dealt with?

1884


What is the difference between the standard and metrics folder?

682


What are products of cognos?

757


What are the types of hierarchies?

758


Please explain the different stages in creating a report in cognos report net?

751


What is the metric store database?

710