Interested to Buy Any Domain ? << Click Here >> for more details...
what is view? types of views?
- 3 Answers
- 7882 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 |
What is the difference b/w macros and prompt?
Write various indexes used in cognos?
how many types of keys are there i.e primary key and foreign key etc..?
what does my folder and public folder contains? difference between the my folder and public folder?
What are all the types of report?
what is a join? what are the types of joins?
What are shortcuts? Where it can be used? What are the advantages?
For example I developed some reports on employee package now I have to develop same reports to another package.How can I change reports to another package?
What is the use of Generated Prompt? Where is it used in realtime project?
What is limited local? and the uses?
How applying "Level Span" in Cognos 8.3?
what is an sid (surrogate key)?
Teradata 
