what is view? types of views?
- 3 Answers
- 6842 Views
- HCL, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / k naveen kumar
View is mirror image to the base table(main table) i,e it is
a logical pointer to the base table.
for the view it does not occupy space for the data but it
occupy space for the structure
Two types of views
1) simple 2) complex view
simple view created on single table
complex view created on multiple tables.
| Is This Answer Correct ? | 3 Yes | 0 No |
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 |
Answer / arkchowdary
A view is, in essence, a virtual table. It does not
physically exist. Rather, it is created by a query joining
one or more tables.
Creating a VIEW
The syntax for creating a VIEW is:
CREATE VIEW view_name AS
SELECT columns
FROM table
WHERE predicates;
| Is This Answer Correct ? | 0 Yes | 0 No |
-------------How to create a PortalTab?
drillthrough vs master detaild report,which one is the best by performance?
What is Cognos Mashup Services .what is the use of Cognos Mashup Services and where to use.
4. How many dimensions did you use in your reports?
How do you improve the performance of the Cognos Analytics report
When we use consume in cognos?
If anyone need COGNOS 8 Certification Dumps of any "COG - Code", u can get from S_Cog@Yahoo.Com, i scored 100 % with these Dumps
Give the advantages of cognos?
how to explain tne project at the time of interview? where to start and how to end? plz explain in detail thax in advance
In how many ways we can apply the security to a cube in Transformer? Explain?
Can anyone explain the procedure for configuring cognos8 with oracle as Content Manager/Content Store? I know the configuration of cognos8 with SQL SERVER (Like how to create CM database in oracle and applying securities to access that Database from cognos8 (Cognos Configuration)
How u provide security to reports in report studio or in cognos connection?
Teradata 
